Search code examples
sql-serverweb-servicesconnectionoledb

Migrate from SQL server 2008 to 2012

I have successfully migrated all my databases from 2008 to 2012 and mapped the user to the specific databases.

My problem being is 2008 expired (hence why I got 2012) and I was using a web service to call/edit data in the tables.

When I run a web service function it just times out which suggests to me that it is still trying to talk to 2008.

I am using -

using System.Data.OleDb;
using System.Data.SqlClient;

with connection -

OleDbConnection objConnection = null;
OleDbCommand objCmd = null;
String strConnection, strSQL;
strConnection = "Provider=sqloledb;Data Source=.;Initial Catalog=NSN;User Id=userID;Password=password;Connect Timeout=300";

My question being, how can I tell the web service to point at SQL server 2012 now that I have migrated all the databases?

Solution

  • If your SQL Server 2008 has expired why dont you then remove the access for the user mentioned in your connection string to the SQL 2008 Db or best make it offline. If the application fails then you know that it was still pointing to SQL2008.