Cannot connect database - test connection failed

General Questions/Discussions
1

Hi,
I was trying to connect to database which is SQL Server 2005 but I got the message -
cannot connect to the database - connection failed.
for your information I am using dial up connection and I got the file vp.log
in my bin directory.

Maksuda

2

Hi Maksuda,

Thanks for your post. Could you please send the vp.log file for us to estimate the problem? Thanks!

Best regards,
Lilian Wong

3

Thanks for the reply.
Please find the attached vp.log file

Regards,
Maksuda…
vp.log

4

Hi Maksuda,

Thanks for the log file. Please try to download the Adapter file by clicking the green down arrow beside the Driver file field (see image below) and see if you can connect to the SQL Server.

If the problem is not solved yet, please refer to the resources page about connecting to SQL Server in the following link for solving your connection problem:
http://resources.visual-paradigm.com/index.php/tips-support/53-support/95-sql-connection-problem.html

If there is any further inquiry, please do not hesitate to ask.

Best regards,
Lilian Wong

dl_adapter.png

5

Thanks for your teply.
I already tried what was in the link before I mailed you.
One thing you know- I am surprise when I was entering my password - I could see it. It should be asterisk(*) sign when I was typing.
Please find the attached file wher you could see the it.

Thanks in advance for the support.

Regards,
Maksuda…
FailedToConnect.doc

6

Hi Maksuda,

Thanks for replying. You entered “bns/MHossain” in Username field, which should be the problem of connection failure. May I know what is “bns”? Is it the domain or something else?
Also, may I know are you using Windows Authentication?

And for the password issue, the password will be hidden in the configuration file.

Best regards,
Lilian Wong

7

Thanks Lilian.
BNS is my domain name ans I’m using windows authentication.
In the configuration file I even could see my password when I was typing all the credentials…that is my another concern.
May be after connection password will be hidden.
But I could not create connection.

Thanks for the support.

Regards,
Maksuda

8

Hi Maksuda,

Thanks for replying. Since you are using Windows Authentication, you need to enter connection URL under Connection string inside the Database Configuration dialog (this is also mentioned in the link I provided, please refer to the “Authentication Method” section). For .NET, the URL required is:

Server=%HOST%,%PORT%;Database=%DATABASE%;User ID=%USER_ID%;Password=%PASSWD%;Trusted_Connection=Yes;Domain=%WINDOW_DOMAIN%
(so you need to input “MHossain” as User ID and “bns” as Domain)

Hope this helps. Please feel free to contact me again if you need any assistance.

Best regards,
Lilian Wong

9

Hello

I have problem with connecting SQLExpress 2005 database. I tried everything, and still no results.

I set SQL server to accept both, windows and sql authentication, and this is what I get when try to connect via VS2005

http://img16.imageshack.us/img16/7972/screenshot001mhg.jpg

These are my settings for SQL Server

http://img16.imageshack.us/img16/5253/screenshot002icm.jpg

http://img48.imageshack.us/img48/4388/screenshot006x.jpg

http://img16.imageshack.us/img16/4047/screenshot003l.jpg

http://img16.imageshack.us/img16/2838/screenshot004bmp.jpg

http://img16.imageshack.us/img16/7976/screenshot005hrn.jpg

http://img48.imageshack.us/img48/9140/screenshot007s.jpg

http://img48.imageshack.us/img48/7316/screenshot008r.jpg

and finally

http://img48.imageshack.us/img48/4010/screenshot009r.jpg

And now when try to connect to ORProba database from SDE I got error

http://img48.imageshack.us/img48/6205/screenshot010x.jpg

password is same as in case of VS connection

http://img48.imageshack.us/img48/9922/screenshot012n.jpg

http://img213.imageshack.us/img213/7803/screenshot011j.jpg

Please Help !!!

10

Hi Zilot,

Thanks for your post. Could you please rename the vp.log file inside VPSuite/bin folder to something else, then start SDE-VS again and try connect to your database with the configuration details of your last image (i.e. hostname=localhost, port=1433, Database name=ORMProba, Username=sa). After that there will be a new vp.log file generated, could you please it to me to take a look?

Best regards,
Lilian Wong

11

Hello

i figured out how to solve the problem,

http://img246.imageshack.us/img246/7162/screenshot002f.jpg

http://img148.imageshack.us/img148/7051/screenshot001f.jpg

I suggest you to write detail explanation for this issue, it can be problem

12

BTW I have no firewall enabled (default widows one is disabled)

13

Hello Wong

SDE didnt make another vp.log (I deleted old one), nut I copy paste details in error window, I suppose it is relevant. Here it is

http://img13.imageshack.us/img13/5710/screenshot001qtp.jpg
log.txt

14

Hi user,

May I know did your connection problem solved eventually? As your posts show that you solved the problem but the connection problem seems to appear again…

Best regards,
Lilian Wong

15

Hello

Posts are missordered, one with vp.log should come first. In the meantime I figured out how to solve the problem, and wrote it in the post that come first

16

Hi Zilot,

Thanks for replying and I’m sorry for the misordered posts! It’s a good news that you resolved the connection problem. :slight_smile:

Best regards,
Lilian Wong

17

hi,

I too have the same problem.i.e. I am working in MOSS 2007. When i tried to open the central admin i am getting an error prompt saying that "cannot connect to the connection database".The problem is somebody has uninstalled the sql server that was running.Is there any possibility of rollback of the lost data?
18

Hi user,

Thanks for your message. Could you please attach a screenshot of Database Configuration dialog? Thanks in advance!

Best regards,
Lilian Wong