|
|
Rank: Newbie
Groups: Member
Joined: 12/5/2006
Posts: 2
Points: 0
Location: SLC, UT
|
I'm trying to connect to my SQL Server via myLittleAdmin and I get the following error:
.Net SqlClient Data Provider
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 41 - Cannot open a Shared Memory connection to a remote SQL server)
I have checked my server and I have 'remote connections allowed' checked on the server.
What am I missing?
chfran
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Hi
You should try to use TCP/IP protocol to connect to your SQL Server.
While on the connection page, click on the Options button, then in Network protocols choose TCP/IP.
You can set TCP/IP as the default value by editing the config.xml file.
If it does not work, please post your configuration and connection info.
Thanks to keep me informed.
|
|
Rank: Newbie
Groups: Member
Joined: 12/5/2006
Posts: 2
Points: 0
Location: SLC, UT
|
That worked. I'll modify the config.xml file.
Now, when I use Windows Authentication to connect to the DB, I get the following error.
.Net SqlClient Data Provider
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
What am I missing?
chfran
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
myLittleAdmin is a web-based application. Thus, we really recommend to user SQL Server authentication. If you want to use Windows authentication, then your IIS server must be configured so that Anonymous Logon is not allowed. You will then need to fill a Microsoft Logon Dialog Box before browsing myLittleAdmin. If IIS and SQL Server are not on the same box and you want to use Windows Authentication, then you will have to check a lot of things. You can find more details on http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch05.asp
|
|
|
Guest |