Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sven2
Yak Posting Veteran
57 Posts |
 Posted - 2009-12-16 : 08:18:56
|
| Hello,I have found an microsoft atricle (http://support.microsoft.com/id=884457) that gives information how to connect an adp access file with an SQL server. This works perfect for a local server but I can't get it to work with a SQL on a network. Does anybody know the way how to automatically connect with a SQL on a network?Thanks in advance,Sven. |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-12-16 : 08:23:44
|
quote:
Originally posted by sven2
Hello,I have found an microsoft atricle that gives information how to connenct an adp access file with an SQL server. This works perfect fot a local server but I can't get it to work with a SQL on a network. Does anybody know the way how to automatically connect with a SQL on a network?Thanks in advance,Sven.
Use the SQL Server Configuration Manager to enable network protocols. To enable network protocols * Click Start, point to All Programs, Microsoft SQL Server 2005, Configuration Tools, and select SQL Server Configuration Manager. * Expand the SQL Server 2005 Network Configuration item. * Select you SQL Server 2005 instance name. * In the right-hand pane, perform one or both of the following: For Agenda Manager 7.1/7.2: Double-click Named Pipes and set the Enabled option to Yes. * For Laserfiche Server 7.2 and Workflow Suite 7: Double-click TCP/IP and set the Enabled option to Yes. * You must restart the SQL Server service before the changes take effect. -------------------------R... |
 |
|
|
sven2
Yak Posting Veteran
57 Posts |
Posted - 2009-12-16 : 09:07:26
|
| Hello,the thing is when I start up SQL server 2005 en type in the name of the server I can connect to that server. But in the SQL Server Configuration Manager the servername isn't visible (only the local servers are visible) ...Sven. |
|
|
|
|
|
|
Connection with SQL server