question

suhasini avatar image
suhasini asked

SQL2000-SQL2005 connection string

My requirement is to upload access database data( from remote clients )on to MSSQL server 2005( which under firwall) . I have written windows application using vb.net code. I have used 1433 port in my connection string to connect mssql2005. It is not working as 1433 is not open. So please tell me an alternate solution to write the connection string in my application.

regards SS

sql-server-2005connection-string
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
RickD avatar image
RickD answered

Change the port number to the port that has been opened for SQL Server. Ask the network admin for which port this is or log on to the SQL Server maqchine and look in the configuration tools -> SQL Server Configuration Tools under TCP/IP.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.