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 |
|
thechasboi
Starting Member
2 Posts |
 Posted - 2010-05-07 : 16:53:31
|
| I have a server 2003 32 bit box that needs to connect to a server 2k8 x64 with sql server 2k8 x64 on it. I downloaded the "Microsoft SQL Server 2008 Feature Pack" and installed, but I still can not connect. I need to connect in two ways the DSN and straight in classic asp code. I have not been able to connect either way. The servers are not on a domain, the office is too small for that. The server is not a default instance if is instance of server on the server name ie. s1/s1. The 23 box has both web and db 2k5 on it so the code is not in question. The question is how in the world do i connect.Thanks for the reply. |
|
|
thechasboi
Starting Member
2 Posts |
Posted - 2010-05-10 : 21:30:59
|
| Any one can help or point in the right direction |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-05-11 : 07:51:48
|
| Can you connect using sql server management studio? Are you sure the service is running like it's supposed to? What does your connection string look like? When you need to connect to an instance that is not the default you also need to specify the instance name, like this: machinename\instancename.Here is a connection string you can use in your classic asp:ConnString = "Data Source=myServerAddress\instancename;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
|
|
|
Connection question