July 12, 2011 at 3:04 pm
Hi,
I am using sql server 2008 on win 2008. I restored a database from sql server 2000 to 2008, and also installed the application using the SQL 2000 Db to new server. But I am having connection problems. The application is not able to connect to the database. Any ideas as to what went wrong and how it has to resolved. I also recreated the system dsn on the new server.
Thanks
SVR
July 13, 2011 at 4:53 am
Please post more details on your connection problems. Error messages and connection string (scrubbed so you don't give away secret info) would be helpful.
July 13, 2011 at 7:06 am
When I am trying to login to the application using admin account it , Not able to connect to the database. That is it .It says nothing else.
Thanks
SVR
July 13, 2011 at 7:13 am
is the new 2008 server an express version? is it a defaul instance or a named instance?
have you been able to connect to it before?
have you eliminated any networking issues already(can you connect to it REMOTELY via SSMS, for example? can you ping it? did you check windows firewall on the client?
what does your connection string in your app look like?
the actual specific error tells us a lot...is it timing out with server not found? activly refused? username/password error?
Lowell
July 13, 2011 at 7:24 am
Check the server Event Viewer logs (especially Security) for around that time frame. What do they say?
The connection string would be helpful. Maybe a screenshot of the error as well.
July 13, 2011 at 7:43 am
It is SQL server 2008. The application is installed on the server it is trying to access. Using a system DSN to connect to the db. And the system dsn is using the driver c:\Windows\system32\sqlncli10.dll. I hope this helps you to get my prob!
SVR
July 13, 2011 at 8:06 am
Hi ,
Nothing is getting logged in the event viewer from the application.
SVR
July 13, 2011 at 9:04 am
SVR (7/13/2011)
It is SQL server 2008. The application is installed on the server it is trying to access. Using a system DSN to connect to the db. And the system dsn is using the driver c:\Windows\system32\sqlncli10.dll. I hope this helps you to get my prob!SVR
Once again, what is the connection string in the App? I've never seen an App without an actual connection string. If you're referencing the .dll directly, instead of using a connection string, that might be your problem.
In the ODBC Data Source Administrator, what does the Name / Driver actually say? Metafile / SQL Server or something else?
July 13, 2011 at 9:11 am
SVR (7/12/2011)
Hi,I am using sql server 2008 on win 2008. I restored a database from sql server 2000 to 2008, and also installed the application using the SQL 2000 Db to new server. But I am having connection problems. The application is not able to connect to the database. Any ideas as to what went wrong and how it has to resolved. I also recreated the system dsn on the new server.
Thanks
SVR
Did you remember to migrate any login accounts (Windows and\or SQL) that are used to access the database through the DSN??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2011 at 11:37 am
It occurs to me that I've been assuming your application is an in-house developed app. Is that correct or is this a third party app you're using?
If the former, you should be able to get your devs to supply the connection string.
July 13, 2011 at 11:42 am
It is a third party app.
it connects to the database using the dsn using a driver.
July 13, 2011 at 11:47 am
I think it's time to call the vendor. It might be an issue with the application itself, especially if they never upgraded it to use SQL 2008, and we can't help you resolve that.
July 13, 2011 at 12:04 pm
Thank You for your time. Appreciate it.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply