SQL database connection

Question

Hi,

I am trying to connect to sql database (.mdf file) but couldn't successfully create a connection string.

Here is what I tested with  -

1.  Data Source=.\SQLEXPRESS;AttachDbFilename=C:\.....	est.mdf;User Instance=True;Trusted_Connection=Yes;
2.  Server=.\SQLEXPRESS;AttachDbFilename=C:\....\Test_models.mdf;User Instance=True;Trusted_Connection=Yes;MultipleActiveResultSets=True;Pooling=True;Connect Timeout=60
3.  Server=.\SQLEXPRESS;Database=C:\.....\Test_model.mdf;User Instance=True;Trusted_Connection=Yes;

Has anybody tried connecting to sql database file (2008) with absolute path?

Is it the User Interface property thats not supported by ESRI?

Any ideas?

Thanks!

jp · Answer

I fixed it by selecting SQL Server Native Client 10.0 instead of SQL Server.

And also had to change the server name to another server.

Thanks all for your help.

GeorgeFaraj · Answer

I tried connecting in ArcCatalog.

Selected Microsoft OLE DB Provider for SQL Server

Connection - 
1. server name : .\SQLEXPRESS, 
2. authentication: OSA, 
3. Attach a database file - path to the database

When I test the connection get this error -

Test connection failed because of an error in initializing provider. CREATE DATABASE permission denied in database 'master'.

Any ideas?

Thanks!

How are you logging in to that machine?  Is it a domain login?  OSA says to use your machine login and SQL Server is telling you that user has no  permissions on that database. Add that user to the database if you want to use that login.

jp · Answer

I tried connecting in ArcCatalog.

Selected Microsoft OLE DB Provider for SQL Server

Connection - 
1. server name : .\SQLEXPRESS, 
2. authentication: OSA, 
3. Attach a database file - path to the database

When I test the connection get this error -

Test connection failed because of an error in initializing provider. CREATE DATABASE permission denied in database 'master'.

Any ideas?

Thanks!