MS SQL Server (Spatial) Writer: Connection Failed. Connection string 'Provider=SQLOLEDB;Data Source=srv-onscene-tes
Provider error '(-2147467259) 5DBNETLIB] IConnectionOpen (Connect(().] SQL server does not exist or access denied.
Any suggestions would be helpful.
Thank you,
Joan
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.