Problem With SqlConnection.ConnectionString

Hello.

I have a Windows 2000 server and I define two Workgroup on it;
Workgroup1 and Workgroup2.
in each workgroup be defined some server that belong to my user computers.
I Install SQL Server 2000 Enterprice On a computer in Workgroup1.
I want to connect from a computer in Workgroup2 to SQL Server 2000 in Workgroup1.
What is proper ConnectionString;

this connection string is not work :
"Server=Myserver;initial catalog = my_database_name; . . . . . ."
// My Server is that name of computer in workgroup1 that I have installed
SQL Server 2000.

Thank you.
LVL 1
MOH_RAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

big_lewCommented:
What type of authentication are you using?  Check to see which mode you are using then try setting to mixed-mode

In SQL Server 7.0, the key is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft \MSSQLServer\MSSQLServer\LoginMode

In SQL Server 2000, the key is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
MicrosoftSQLServer\<instance_name>\MSSQLServer\LoginMode

The value of LoginMode is 1 for Windows Authentication only, and 2 for Mixed Mode. After locking yourself out, you can change the value of LoginMode to 2, restart SQL Server, and log in as the system administrator (sa), provided you know the sa password.

Here is a good article on understanding connection strings:

http://www.codeproject.com/aspnet/SQLConnect.asp

Hope this helps...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.