an error has occurred while establishing a connection to the server

Dipa Ahuja

16y4.7k

helo.. i create my website of asp.net with sql server2005 in my pc.

but when i try to run it on my friend's laptop its not working and giving this error:

When I try to enable remote connection then it giving the error of access denied..

In my pc its XP sp2 and in laptop its vista. I have no idea how to solve this access denied problem( thought the user account has rights of administrator) in vista because in XP i have never faced this problem.

Then I try to create new database in my website, but it doesn't allow to add new DB and giving the same sqlerro26..

Everything working fine in my pc but not in this laptop.

and also when i try to run my page in google chrome its shows webpage is not available but in IE and firefox its working fine

How to solve this problem?? Plz reply soon…

Thank you!!

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Venkatesan Jayakantham16y ago
Hi,
Google chrome will be having an extra authetication for loading the pages whereas it's not the case with IE.
Hope you can start looking in this area.
Cheers,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/

0
Dipa Ahuja16y ago
But y only with google chrome??

it just not running in the google chrome browser..

its running perfectly in firefox and IE...
0
Kirtan Patel16y ago
you need to Enable remote connections to your sql Server instance then you can connect

follow the below procedure ....
1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.
  
  Note Click OK when you receive the following message:
  Changes to Connection Settings will not take effect until you restart the Database Engine service.
4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.
0
Dipa Ahuja16y ago
i tried, even simple page is not running in chrome

n i dont know y ..

its working in my pc (OP XP) but not in laptop(OP Vista)..

dont know wts the reason..
0
Crish16y ago
hi

For finding exact cause...you need to go step by step like ...first create sample page which is having static content. Try to open it on Google chrome...then after try dynamic simple page where you just display dynamic data from database.

If both steps working fine then possible your default page having any services which can not supported by google chrome or not loaded that services by chrome.
0
Dipa Ahuja16y ago
Thanx for reply..

but i tried this solution and star/stop this service.. but it wasnt working.

then i reinstall the sql server .. then also it wasnt working and gave another error:

"Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."

but then i solved from:

http://aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx

now it working fine..

but the error of google chrome is still there..

even i have never faced the browser problem.. but dont know whats the reason..
0
Amit Choudhary16y ago
hi diya,
Well you have asked for too many things in one post..
Try to add an administrator from Surface area Configuration tool from
Start->AllProg->Microsoft Sql Server->Configuration Tool
then try to change your setting
Go to
start > Programs > SQL server 2005 > Configuration Tools > SQL Server 2005 Surface Area Configuration.

Click on "Surfacr Area Configuration for Services and Connection"
Enable Remote Connection option. After doing this try
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.
your second problem "and also when i try to run my page in google chrome its shows webpage is not available but in IE and firefox its working fine"
i thing there is nothing you can do with it.. i have never faced problem with browsers..
Hope it helps
Please mark " Do you like this post" if it helps you.
0