Dear All,
I have posted my question as below.
But no answers, hope it can found here.
I have posted my question as below.
But no answers, hope it can found here.
-
-
Re: Cannot connect database
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 connectionstrin g in vb.net 2005 program.
<add key="SGSQLConn" value="Data Source=10.1.1.9 1;Initial
catalog=Testing ;Persist Security Info=True;User ID=raymond;Pass word=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 connectionstrin g 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.
----------------------------------------------------------------------------------------------
Are you sure you are not using integrated security on with Visual Studio?
Cor
-
Re: Cannot connect database
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]" <notmyfirstname @planet.nlwrote in message
news:9FABCCC3-9B3C-4D99-A8B9-D3099854BD08@mi crosoft.com...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 connectionstrin g in vb.net 2005 program.
<add key="SGSQLConn" value="Data Source=10.1.1.9 1;Initial
catalog=Testing ;Persist Security Info=True;User ID=raymond;Pass word=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 connectionstrin g 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.
>
----------------------------------------------------------------------------------------------
>
Are you sure you are not using integrated security on with Visual Studio?
>
Cor
>
>
>
>
>
>
>
Comment
-
Re: Cannot connect database
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
"Raymond Chiu" <rchiu5hk@yahoo .com.hkschreef in bericht
news:%2355dIXHv IHA.5244@TK2MSF TNGP02.phx.gbl. ..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]" <notmyfirstname @planet.nlwrote in message
news:9FABCCC3-9B3C-4D99-A8B9-D3099854BD08@mi crosoft.com...>>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 connectionstrin g in vb.net 2005 program.
><add key="SGSQLConn" value="Data Source=10.1.1.9 1;Initial
>catalog=Testin g;Persist Security Info=True;User
>ID=raymond;Pas sword=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 connectionstrin g 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.
>>
>----------------------------------------------------------------------------------------------
>>
>Are you sure you are not using integrated security on with Visual Studio?
>>
>Cor
>>
>>
>>
>>
>>
>>
>>
>Comment
Comment