Cannot connect database

[Raymond Chiu]

Dear All,

I have posted my question as below.
But no answers, hope it can found here.

http://forums.microsoft.com/msdn/Sh...8ca5e2acbf8709a7521a&ticks=633469349810029562

 

[Cor Ligthert[MVP]]

Raymond,

Most of us don't like to open a link especially not when it is from somebody
from a chinese area because of the much malafide spam which as been in these
newsgroups from that area. In this case it is obvious that it is not, but a
lot of people don't even look at that at it is from China (Hong Kong) in
this case

You just can copy and paste
---------------------------------------
I am using the following connectionstring in vb.net 2005 program.
<add key="SGSQLConn" value="Data Source=10.1.1.91;Initial
catalog=Testing;Persist Security Info=True;User ID=raymond;Password=abc"/>

(1) It cannot open the connection and prompt the error that <cannot open
database "Testing" requested by the login. The login failed. Login failed
for user 'raymond'.>

(2) When I remove initial catalog, connection can be open and when fill to
the dataset, it prompt error that table no found.

(3) When put in asp.net program with altering connectionstring to be usable
in sqldatastore using same userid and password, I can connect to the
database and see the tables.

(4) Using same userid and password and ipaddress, I can connect to the
database and withdraw data using studio management express.

 

[Raymond Chiu]

Dear Cor,

Could you tell me how to check this?
The main point is where to change the setting in my computer or in Remote
SQL Server?

Thanks for your help.

Raymond

 

[Cor Ligthert[MVP]]

Raymond,

The first thing you have forever to check in this, is if your SQL database
(the database itself) has the right security settings for what you are
doing.

Cor