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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-07-27 : 01:13:03
|
| Hi All,I have some 3rd party tool installed on 32 Bit Windows server.In the tool i have pointed shared SQL server to write data.I am using sql server authentication.when i tried to connect to database it says unable to connect.But the same kind of setup is working on my local machine.I have used profiler to trace the login host name. My local machien is gettign logged but not even a single connection made from the server.How do we debug this please help me.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-07-27 : 15:55:19
|
| How r u connecting to sql server? |
 |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2011-07-28 : 06:40:39
|
| Login to the server where the 3rd party application is running, and create an empty text file. Rename the file, calling it "test.udl", and the double click on it to open it. This will allow you to create a test connection to your server. In the dialog that opens. Click on the Provider tab, and select OLE DB Provider for SQL Server. Click on the Connection tab, populate to login details of your SQL Server, and click the test connection button. This will tell you whether you can actually connect to you SQL server from the application server.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
|
|
|
accessing SQL server from 3rd party application