Sqlserver does not exist or access not allowed

[sjakiePP]

When trying to connect to the sqlserver i get following error message: Sqlserver does not exist or access not allowed.

It occurs when I try to connect to the database from a webservice with Windows authentication. The database is on a different machine in a different domain.

How can I get access to this database? Is the best way to use sql authorization? Or is there any other way of establish a connection to the database?

Thanks in advance.
Sjakie

----------
Yes, the world is full of strange people.

 

[camy123]

really the best method is windows authentication but but from a webservice you would mst likely use SQL i suppose but you could use windows authentication. well its sayin SQl srver does nto exist so check if the servername is correct ... then create a temp ODBC connection to see if you can access the server from the pc you are accessing the webservic from, check to see if the server is running ,
let me know how u get on .

 

[tran008]

You may also want to open sql client network utility and add a Named Pipe alias.

thxs....

 

[SQLBill]

The error you are seeing is usually caused by using a non-trusted domain. If you look in the SQL Server error log, you will probably find login failed errors for (null) account. That's you trying to login via Windows Authentication from a non-trusted domain.

What makes a trusted domain? The domain you are trying to get to must accept (authenticate) your login/password. That usually means a shared domain controller.

In your situation, you'll most likely need to go to SQL Server authentication.

-SQLBill

 

[sjakiePP]

I have done it with a workaround. I now login on to the domain and then I use a sql user to have access to the database. This works.

Thanks all.
Sjakie

----------
Yes, the world is full of strange people.

 

[kunai]

Hi,

I'm having a similar problem.
I have to use a local user (cannot use domain).
I can connect to the sql server and i can connect to the physical machine itself by using a user/pwd i've created.

But, how can i use VB to integrate windows authentication to connect to the maching and then connect to the sql server?

Thanks for any help.