SQL Server Data Access
Which error do you get
HTH, Jens K. Suessmeyer.
There are many KB articles which walk through remote connections to SQL Express. Please check out the following:
http://support.microsoft.com/kb/555585/en-us - in addition to enabling tcp connections, you need to ensure you have allowed remote connections and setup the firewall correctly.
http://support.microsoft.com/kb/319930/en-us
The error message is -2147217843 Login failed for user 'Master'.
I detached the databases from msde2000 and attached them on SQLExpress 2005.
The connection is
Server = "CMP\SQLEXPRESS"
g_SQLProvider = "SQLNCLI.1"
ConnOpsDB = "Persist Security Info=False;User ID=George;Password=''" _
& ";Data Source=" & Server
With cnOpsDB
.Provider = g_SQLProvider
.ConnectionString = ConnOpsDB
.Open
.DefaultDatabase = "MercDB"
End With
With the above connection string I am getting "Login failed for user 'George'. THe problem is that after attaching the database from MSDE 2000to Sql Express 2005 and using the MS SQL Server Management Studio I cannot set the permissions right. I cannot have the user i want behave as sa. any ideas