Connecting to SQL Server 2005

I installed the SQL Server 2005 Trial and am now having trouble connecting. When I bring up the ASP.NET Configuration tool and Go to "Provider configuration" "Select a single provider for all site management data" AspNetSqlProvider Test I get the following message.

"Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. "

I have already run the aspnet_regsql command-line utility.

Can anybody give me some information on how to set this up.

I am currently working with the club web site starter kit.

I first recommend you go grab this awesome management tool for the express edts :

http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

I would then first check to see if your connections to the DB work with this tool and copy the connection strings it gives you and use them in your app. Also, you can configure ASPNETDB from the web.config level and dont have to use the web tool. This way you can test directoly to ASPNETDB. I havent used the club starter kit but im sure it either uses app_data or aspnetdb in the db. All you have to do is point to the right one. I wrote a couple blogs on this :

http://eramseur.blogspot.com/2005/12/aspnet-20-create-custom-provider-for_10.html

I would also check out scotts entry :
http://weblogs.asp.net/scottgu/archive/2006/02/24/438953.aspx

He has another article about how to get membershp up in 15 minutes and you should look at that too.

Connecting Surface Area Configuration to server on Clustered Server

I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.

Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhost\instancename, but reports the following error:

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:26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)

I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.

Any help will be greatly appreciated.

Can anyone give me a little help here - I can't make configuration changes on production servers.

Thanks.

|||

Well, after a lucky break I found the answer.

sp_configure 'remote admin connections', 1
go
reconfigure
go

Once this was executed on the server I was able to go into Surface Area Configuration, enter the virtual server name, and connect successfully and make the other changes necessary. A simple solution to a scary problem. (Even though I'd used sp_configure for years on both Sybase and MSSQL servers it's easy to forget about the simple solutions.)

Connecting Surface Area Configuration to server on Clustered Server

I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.

Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhost\instancename, but reports the following error:

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:26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)

I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.

Any help will be greatly appreciated.

Can anyone give me a little help here - I can't make configuration changes on production servers.

Thanks.

|||

Well, after a lucky break I found the answer.

sp_configure 'remote admin connections', 1
go
reconfigure
go

Once this was executed on the server I was able to go into Surface Area Configuration, enter the virtual server name, and connect successfully and make the other changes necessary. A simple solution to a scary problem. (Even though I'd used sp_configure for years on both Sybase and MSSQL servers it's easy to forget about the simple solutions.)

|||thx a lot

connecting analysis services to excel (client side)

Hi,

How is the configuration of connection for a client Excel pivot table connected to Analysis Services? Is there anyway in which when we copy the .xls with pivot table to client PC, it will automatically connect to Analysis Services?

thanks in advance.

cherrie

Cherrie,

Do you have analysis services database installed on each pc and want to connect allways locally? If so, then in connection string instead of specifying machine name, use localhost.

If this is not what you ask, could you please clarify your question. What do you mean automatically connect to Analysis Services?

Vidas Matelis

|||

Hi,

Let's say I have a server in which Analysis Services is located together with my SQL Server database. Since currently, SSAS resides in my local drive from which the local excel is also connected through setting it up in Data > Import External Data > New Database Query > OLAP Cubes and it's doing well. But I'm thinking if let's say I want users to access the SSAS cube from the server to their local Excel? How would I configure the connection?

Thanks!

cherrie

|||

Cherrie,

It looks like you are using Excel 2003. Steps for your users will be exactly the same. You go :

Data > Import External Data > New Database Query > OLAP Cubes > <New Data Source> > etc

Then you specify data source name, provider, click connect and specify "Analysis Server" name. This name could be name of your machine or SSAS Server.

Leave UserID & Password empty, then select database and you are done.

Vidas Matelis

|||

Vidas,

Can the connection be stored in the UDL instead or store the connection somewhere in the local drive of the user apart from the .xls file?

Cherrie

Connect to WMI provider.

In SQL Server Configuration Manager I cannot connect to WMI provider. I have
permission. I don't knowing mount the MMC in windows XP to SQL Server 2005.Hi
Please post SQL Server 2005 CTP/Beta questions in
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"merlin5_5@.msn.com" wrote:
> In SQL Server Configuration Manager I cannot connect to WMI provider. I have
> permission. I don't knowing mount the MMC in windows XP to SQL Server 2005.

Connect to WMI provider.

In SQL Server Configuration Manager I cannot connect to WMI provider. I have
permission. I don't knowing mount the MMC in windows XP to SQL Server 2005.
Hi
Please post SQL Server 2005 CTP/Beta questions in
http://communities.microsoft.com/new...=sqlserver2005
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"merlin5_5@.msn.com" wrote:

> In SQL Server Configuration Manager I cannot connect to WMI provider. I have
> permission. I don't knowing mount the MMC in windows XP to SQL Server 2005.

Connect to WMI provider.

In SQL Server Configuration Manager I cannot connect to WMI provider. I have
permission. I don't knowing mount the MMC in Windows XP to SQL Server 2005.Hi
Please post SQL Server 2005 CTP/Beta questions in
http://communities.microsoft.com/ne...p=sqlserver2005
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"merlin5_5@.msn.com" wrote:
[vbcol=seagreen]
> In SQL Server Configuration Manager I cannot connect to WMI provider. I ha
ve
> permission. I don't knowing mount the MMC in Windows XP to SQL Server 2005.[/vbcol
]