March 9, 2010 at 11:21 pm
I am using SQL server 2005 Express Edition on static IP and want to access this
over the net without using web interface.......
Can anyone help me with the configuration of my SQL server and the connection string that will be required then......
March 15, 2010 at 11:10 am
There is a nice compilation of samples here:
http://www.connectionstrings.com/sql-server-2005
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 18, 2010 at 7:01 am
Actually i need to comfigure and access over the net......
The link u provided does not have such format..Moreover I need to have te detttings done before the Connection String.........
Ne ways thnx for ur support... Hope u try to find out the settings required........
March 18, 2010 at 11:02 am
shonitsonit (3/18/2010)
Actually i need to comfigure and access over the net......The link u provided does not have such format..Moreover I need to have te detttings done before the Connection String.........
Ne ways thnx for ur support... Hope u try to find out the settings required........
Done before the connection string? The connection string is there to enable you to connect to a database. Those constrings can be used over the internet.
Can you explain more explicitly what you are seeking?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 18, 2010 at 11:52 am
Actually I am developing desktop application which requires db access over the net......
The application will be running on different machines located over different geographical locations, but on a centralized database located on a sql server machine.........
This is possible on sql server 2005........but this needs some settings on the sql server 2005 at the server side.........
Actually, I have got some idea that, some port no specifications need to be done.........
Help me...............................:crying:
March 18, 2010 at 11:55 am
You need to configure your firewalls and routers to permit traffic between the locations. The port setting will depend on your database setup (some use default port, others configure a different port number).
You will need to verify what protocols you are using (surface area configuration can show you if you have tcp/ip enabled or just named pipes).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply