MS SQL Server (Spatial) Writer: Connection Failed. Connection string 'Provider=SQLOLEDB;Data Source=srv-onscene-tes
Provider error '(-2147467259) [DBNETLIB] [ConnectionOpen (Connect(().] SQL server does not exist or access denied.
Any suggestions would be helpful.
Thank you,
Joan
+13
When you add the writer it does not really check that the credentials are valid so here are few things to check:
1. In the navigator on the left check the user name, password and server name are all correct
2. Assuming you have a destination feature type already (which represents a destination table) double click on it to get the properties and then go to General tab and check that the user is set to a user with access to the table you want to write to. Here is a screen shot that might help.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
