SQL Server Performance

Help..using sql server 2000

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by Aq_Jamie2002, Jul 25, 2005.

  1. Aq_Jamie2002 New Member


    I'm quite inexperienced with SQL Server 2000 but I have to develop a project on it for my job using VB.NET my problem is the following :

    I have created a DB using sql server at work then, i backed up the DB and took it home to continue the work at home so i restored the Db and when i ran my project from my personal computer it gave me an error message whenever i try to open the connection with Sql server and the message was login Failed for the user by the way the sql server is in the local machine at work and at home so the Data Source=(local) in both cases.

    So, Please Help me....

  2. Luis Martin Moderator

    What kind of authentication do you have in PC?

    Luis Martin

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    All postings are provided “AS IS” with no warranties for accuracy.

  3. ghemant Moderator

    Hi,<br />it seems that you authentication level is set to Windows Authentication,so change the connection string's authentication level ... or change you authenticaion level to Mixed mode in order to get "SA" login, refer the following post gives you an idea how to set authentication mode to Mixed Mode from Windows Authentication mode :<br /><br /<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331</a><br /><br /><br /><br />HTH<br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br /><br /><br />hsGoswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  4. Aq_Jamie2002 New Member

    Hi.. Guys..
    Thanx ghemant....it is working now

Share This Page