SQL Server Performance Forum – Threads Archive

Help..using sql server 2000

Hi, 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….
thanx

What kind of authentication do you have in PC? Luis Martin
Moderator
SQL-Server-Performance.com 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.

Hi, 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 : http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331</a> HTH [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards hsGoswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

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

]]>