We're running a point of sale/inventory management system that uses MS SQL Server as the backend. I'm looking to do some reporting and need to query data from the existing inventory databases but the server is not responding via OSQL and the ODBC "Test Data Source" fails.
osql -L reports:
osql -E -S CONNPOS reports:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
I am logged in as the admin which was the account used to install the server and create the databases.
Have you tried to login using SQL authenthification?
If this succeds, then it means that your user's rights have been removed somehow, if not your connection is down. And I think this is the problem, at least the second message (ConnectionOpen (Connect()) is suggesting that. Probably you were connected to the database, and while beeing connected the connection got lost.
Try disconnecting and reconecting, and check if the server is REALLY running, because it's not necessarily has to run to be reported by the "osql -L" statement.
According to sqlmangr/services panel the server is up and running... I should note that the osql commands were run from the local machine (2000 Server), not from a remote system. I haven't tried SQL auth... just NT.
I did notice that netstat doesn't report ms-sql-* on any TCP ports... hmm.
I have run into this sort of thing before. In the server network utility, you will find a checkbox that says something like "Enable Shared Memory Protocol" (not sure of the wording, so that could be pretty wrong). Uncheck that box. Then retry the query. Good luck.
I am able to connect via OSQL and can execute queries. I have also configured a user DSN for this database via the ODBC Control Panel but can not connect through an ASP script even tho the ODBC data source test passed. Here's the error that is returned to the browser when the script attempts to open a connection:
[Microsoft][ODBC Driver Manager]Data Source Name not found and no default driver specified.
I had selected "SQL Server" as the driver and again, the data source test had passed.