sql server with workgroup?

Question

good evening for all......

I have two computer (windows 7) with hub ,and i have program with database(sqlserver).one of the computer i installed on sql server2008 enterprice ,and another computer i installed  program (designed c#) , i set ip (100.100.10.1)for first ,(100.100.10.2)for second computer ,and opened port (1433) throw firewall ,and enable TCP\IP for sql server ,the connection string (Data Source=100.100.10.1,1433;Network Library=DBMSSOCN;Initial Catalog=Test;User ID=sa;Password=12345;).

but when run program ,showed error (network related ....................)

how solve this problem .....

very very sory if this not Appropriate depart...

with MY REGARDS

Answer 1

Hi Mohamed,

Couple of things that might help. Do you have port 1433 open in the firewall? Also, you shouldn't need "Network Library" specification in the connection string.

Otherwise, you'd have to post the exact error message.

I'll be moving the message to the MSDN "managed provider" forum (that's the one for client connectivity using ADO.NET) in about 5 minutes or so.

Cheers, Bob

Answer 2

• Check SQL server is runing on windows authentication mode or mixed mode? (it should be on mixed as you are using sa user)
• Check SQL Browser service is runing
• Check SQL services are runing
• Check remote conenctions are enabled
• Network conenctivity between database & applicaiton servers by TRACERT command
• Check TCP/IP protocal enabled at SQL server
• Check telent connectivity - telnet <IPadress> <portno on sql server runing>
• Check UDP port 1434 is open or not on SQL Server

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

Answer 3

What is exact error that you get?

---

Val Mazur Microsoft MVP
http://www.xporttools.net

Answer 4

Thanx

Im Found Solutions

There are error occurred when I turned off Fire Wall and give it Port in connection string

this connection string after modified:

Data Source=190.190.200.100\MIRROR; Network Library=DBMSSOCN ;Initial Catalog=testpermission;User ID=Ahmed;Password=1234"