SQL connection to bd in the network

Question

SQL connection to bd in the network

Navigation

#1 by (0 votes)
#2 by (0 votes)

1

I developed a C # application that uses SQL Express that initially the bd and the application were installed on a single machine. The client now needs the bd to be available from another computer on the network. I installed SQL Express on the "other" machine and changed the connection string to:

connectionString = "Data Source = 192.168.1.xx\SQLExpress,1433; Integrated Security=SSPI; Initial Catalog = baseDados;"/>

where 192.168.1.xx is the IP of the machine where the localized database is located. The Tcp / Ip is enabled.

Is this enough to make the connection?
When trying to access the program / database gives the error: "... provider: TCP provider, error 0 - A connection attempt failed because the connected component did not respond correctly after a period of time, the established connection failed because the connected host did not respond"
Can someone help me?

sql-server c# connectionstring

asked by anonymous 14.04.2015 / 13:09

2 answers

0

IP address 192.168.x.x is an internal IP address, what you want is the external IP address of the other computer.

If it is a Windows machine, you can find it by using the ipconfig command on the target machine.

14.04.2015 / 16:17

Panel I can not give a Visible = true on it [closed] Site buga all when hosted [closed]

score 0 · Accepted Answer

Check the properties of the database if the following option is checked:

Initsplace,itwouldnotuseintegratedauthentication.However,ifyouwanttouseit,makesuretheIISuserhaspermissiononthedatabase:

Still, if nothing works, use a regular user with a password. Integrated authentication usually only works for these cases well if the database is integrated with a domain.