A company pulled me in and wanted me to help with their sql server after a raid failure.
They retrieved the data off the drive and re installed on a virtual server.
They hired another company to install sql 7 from scratch and import the data.
The server hosts their website which ties to the SQL server and 2 programs which store data on the sql server.
Now is the part i am confused on and am sure you guys will know it.
I think everything is setup to work through odbc connections. (dsn)
The website is showing this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'bhPress_user'.
/connect.asp, line 15
On the server there are system dsn's and file dsn's in the odbc list.
Since the company installed SQL 7 from scratch i believe sql lost all the login information? Am I on the right path?
How do I go about setting up all these connections back up?
All help is greatly appreciated and thanks for your time guys.