Connection strings issue

Question

Post reply

Connection strings issue

timotech

SSCrazy

Points: 2698
More actions
April 19, 2010 at 4:57 am

#223540

Hi,
I have this connection string in vb.net that connects to my sqlserver 2005 locally, but does not work on the network, i.e does not connect with another computer when i publish it, what can i do.
In other words, i want to run my application on a network with one single database, that multiple users can connect to. thanks.
<add name="MMSConn" connectionString="Data Source=PROGRAMMER\FREDSQLSERVER;Initial Catalog=MediaMonitoring; Integrated Security=True" providerName="System.Data.SqlClient"/>
If this is not the right forum, pls direct me to one. thanks
Timotech

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

try:

http://www.connectionstrings.com/

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

timotech SSCrazy Points: 2698 More actions · Answer 2

Hi Henrico,

been there already, i tried some of the options locally, but they did not work, for example when i try:

it doesn't connect.

i also setup an ip address in sql server configuration manager and used this:

but it does not work also, what can i do so that anyone on the network can connect to my sqlserver database in sqlserver 2005

Thanks

Timotech

VijayakumarKP Old Hand Points: 363 More actions · Answer 3

Hi,

To let ASP.NET to search the database location, use the following connection strings in the web.config in specific cases

-> in the default data folder

connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"

Vijay

😛

timotech SSCrazy Points: 2698 More actions · Answer 4

Thanks vijay, but i'm using windows forms, with asp.net its quite easy, i go through localhost or the webserver, but i don't know how to do so for windows forms.

timotech SSCrazy Points: 2698 More actions · Answer 5

Hi Everybody, i saw a video from asp.net site that solved my problem concerning this issue. the video number is 07, sql security and network connection.

This is the link to the video, hope it solves other peoples problems too.

http://www.asp.net/learn/sql-videos/

Thanks

Timotech.