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 |
|
artsapimp
Starting Member
7 Posts |
 Posted - 2002-07-02 : 15:28:31
|
| I am trying to take an existing application (asp) I made for MS Access 2000 and convert it to SQL Server. I have VERY little SQL server experience so I appologize if my questions sound basic. The application lists all databases in an existing folder (*.mdb) and allows the user to open the database showing all tables/queries in that database. This is easy to do using asp and Access but I am having a problem connecting to to the SQL server to list the databases. Setup: 2 servers - 1 WWW server (MyWWWServer) 1 SQL server (MySQLServer) I have installed the client software on MyWWWServer for SQL server but it still does not allow me to have access to the SQL server (I administer both servers... scary huh?). I am using Windows & SQL authentication on the SQL server and the client is setup for Use Windows Authentication. The error I get when trying to connect is "SQL Server registration failed because...SQL Server does not exist or access denied. ConnectionOpen(Connect())." Am I wasting my time or do I need the client installed? Is this what's stopping me from accessing the SQL server? Thanks for any help. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-07-02 : 15:52:55
|
| What version of SQL?You don't need the client tools to access SQL through ASP.But, you shouldn't be getting a problem registering the server. Are they in the same domain? What NetLibs is the server listening on? Is the client setup to connect to the same NetLib. Is the MSSQLServer Service started? Can you ping (By name) the SQL Server box, from the WWW box?Those are the types of things that will cause the error you are getting. -Chad |
 |
|
|
|
|
|
SQL Authentication (asp)