Visual Web Developer 2008 Express

Re: Unable to connect to SQL Server database

AvanthaSiriwardana — Sat, 04 Jul 2009 04:28:51 GMT

NO Prob

All the best

Re: Unable to connect to SQL Server database

coderchef — Fri, 03 Jul 2009 14:39:31 GMT

sorry about that

new to forum. should be all set

thanks again

Re: Unable to connect to SQL Server database

AvanthaSiriwardana — Fri, 03 Jul 2009 03:20:35 GMT

Then why can't you my 1st answer as the correct one. please do that whn you get a correct answer pal.

Tnks

Avantha

Re: Unable to connect to SQL Server database

coderchef — Fri, 03 Jul 2009 00:57:50 GMT

Problem Resolved

Did a complete uninstall and reinstalled a fresh VWD2008 express and SQL server 2008 express and I am now able to access the security tabs page.

Thank you for your responses and help

Re: Unable to connect to SQL Server database

shahed.kazi — Thu, 02 Jul 2009 11:49:02 GMT

Check if you are passing on the correct credentials to connect to the sql server.

Re: Unable to connect to SQL Server database

AvanthaSiriwardana — Thu, 02 Jul 2009 05:58:10 GMT

if its windows authentication then check whether you have the

privileges to create roles. Try to give the administrator role and then create a user and see..

Re: Unable to connect to SQL Server database

coderchef — Wed, 01 Jul 2009 19:24:18 GMT

Thank you,

I have went through those steps. Everything is a check.

I have been able to link the database with VWD and create some pages with the data such as gridviews.

Its just when I go into the security tab to create a user login is where I get the "Unable to connect to SQL Server database"

I am currently looking to see if the role manager is the problem.

Re: Unable to connect to SQL Server database

AvanthaSiriwardana — Wed, 01 Jul 2009 07:20:18 GMT

there can be several things

could be no permissions

could be no remote access

could be serevr service not started

could be worng username and pasword

could be that the user name or password have been changed

one by one..

check if the service is statrted first of all

from the SQL Server configuration manager

then check if he can log into the server from managem,ent studio

then check if there is connectivity from teh asp.net application machine to the SQL server machine

there can be several things

could be no permissions

could be no remote access

could be serevr service not started

could be worng username and pasword

could be that the user name or password have been changed

one by one..

check if the service is statrted first of all

from the SQL Server configuration manager

then check if he can log into the server from managem,ent studio

then check if there is connectivity from teh asp.net application machine to the SQL server machine

Re: Unable to connect to SQL Server database

AvanthaSiriwardana — Wed, 01 Jul 2009 07:13:31 GMT

Unfortunately I alos came up with the same issue when i was configuring that connection to the server. I also did every thing what these people have mentioned and nothing worked out.

What i did was, uninstall the VS and the SQL Server and then Install VS first and SQL Server 2nd and i solved my problem.

Unfortunately I alos came up with the same issue when i was configuring that connection to the server. I also did every thing what these people have mentioned and nothing worked out.

What i did was, uninstall the VS and the SQL Server and then Install VS first and SQL Server 2nd and i solved my problem.

Re: Unable to connect to SQL Server database

reza141414 — Wed, 01 Jul 2009 06:15:51 GMT

hi boy;

see this link:

http://msdn.microsoft.com/en-us/library/ms998314.aspx

and

http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/9e0afc71-5156-44b2-9443-b05c74376c62

Re: Unable to connect to SQL Server database

coderchef — Tue, 30 Jun 2009 15:33:24 GMT

Thank you for your response,

I am not able to view anything other than the message ont the security tab

http://4.bp.blogspot.com/_qFuBktPwZYQ/SkotQVEGMcI/AAAAAAAAEZ4/5ge2MDmA_as/s1600-h/vwd1.JPG

http://1.bp.blogspot.com/_qFuBktPwZYQ/SkotzWrvbNI/AAAAAAAAEaA/X7iPdsqGKW4/s1600-h/vwd2.JPG

http://1.bp.blogspot.com/_qFuBktPwZYQ/SkouXq92NYI/AAAAAAAAEaI/aodtZgN3CpM/s1600-h/vd3.JPG

I have made a connection to an sqlserver express database that seems to work ok

http://4.bp.blogspot.com/_qFuBktPwZYQ/SkpeqXwyYwI/AAAAAAAAEaQ/OdHkuxiZCsc/s1600-h/data+connecton.JPG

My connection string is:

Re: Unable to connect to SQL Server database

reza141414 — Tue, 30 Jun 2009 07:28:52 GMT

can you see your seeting from project->asp.net configuration in security tab or not?

for example number of your user?

Unable to connect to SQL Server database

coderchef — Tue, 30 Jun 2009 04:28:48 GMT

Unfortunately I have run into a problem where I am not able to access my security settings in the asp.net configuration.

I get:
"Unable to connect to SQL Server Database."

I have run aspnet_regsql.exe like it suggested but no help.

I previously connected a sqlserver 2008 database to visual web developer 2008 sp1

My web research has turned up empty.

Thank you