next »

[Dutchdarky]

hey,

when i want to connect to the datastore stored on my server i get the following error:

Connection to datastore could not be established ([DBNETLIB][ConnectionOpen(Connect()).] De SQL-server bestaat niet of de toegang tot de server is geweigerd.).

which is translated:

Connection to datastore could not be established ([DBNETLIB][ConnectionOpen(Connect()).] The SQL-server is non exsisting or the access to the server is denied.).

i shared (and gave everyone full rights, just for testing) the database file and the folder it is in, what am i doing wrong? passwords & login are correct too

thanks in advance,
DD

[Dutchdarky]

i forgot to add: i can ping and connect to the server normally

[Nathan Sperry]

Hi Dutchdurky,

Your problem is more related to the SQL server than the RES configuration. My guess is that its has something to do with the protocols defined on the SQL server i.e. named pipes disabled

Here is a good link to a Microsoft troubleshooting article for SQL that might help solve the issue.
http://support.microsoft.com/kb/328306

Also try and telnet to the SQL server on port 1433 to check that's being blocked.

I hope this gets you nearer the solution.

Nathan

[Dutchdarky]

hey,

thanks for your answer, now my first problem is gone. but a second one has risen

when i connect now (i exported/imported the connection string). when i click connect i get the error "connection to datastore could not be established (invalid connection string attribute)"

[Iain Brighton]

Dutchdarky,

If you're using SQL Express, can you check that the SQL Browser service is configured to start automatically (and is started!) on the database server? By default SQL Express will use a dynamic port and RES Workspace Manager will struggle to connect without the SQL Browser service.

Also, within the SQL Configuration Manager make sure that TCP/IP is enabled under the Network Configuration for the Express instance and that firewalls are not blocking you..

Thanks, Iain

[Dutchdarky]

hey,

thanks for your reply, i did everything you suggested (they were all off/disabled) sadly it didnt work.

do you have any other suggestions?

thanks again

DD

[Iain Brighton]

DD,

What server name are you using in the connection information? If it's the default install of SQL Express you will need to specify the Instance name (SQLEXPRESS) too. For example with a server called RESDB installed with SQL Express, you may need to specify the database server name as RESDB\SQLEXPRESS, not just RESDB!

Regards, Iain