Re: MOSS and move SQL database

Hey, if I add the port number ,1709 I can connect. Trouble is I don't know how to add that to your command. I can run

sqlcmd -E -S .\SQLEXPRESS,1709

I also changed the next command to be EXEC sp_detach_db 'WSS_Content', 'true' then it works.

I have done this 2 times on test servers. I will try it a couple more times, but I am almost ready to do it on the production machine.

Thanks for your help.


"Robert Zhao [MSFT]" <v-rozhao@xxxxxxxxxxxxxxxxxxxx> wrote in message news:RGRRtrfwHHA.1568@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi

This problem may occur when SQL Server 2005 is not configured to accept
remote connections. By default, SQL Server 2005 Express Edition and SQL
Server 2005 Developer Edition do not allow remote connections.

To configure SQL Server 2005 to allow remote connections, complete all the
following steps:
1. Enable remote connections on the instance of SQL Server that you want to
connect to from a remote computer.
2. Turn on the SQL Server Browser service.
3. Configure the firewall to allow network traffic that is related to SQL
Server and to the SQL Server Browser service.

The following article describes how to complete each of these steps.

How to configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/kb/914277

I hope it will be helpful.

Have a nice day!


Sincerely,
Robert Zhao
Microsoft Online Support
Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.







From: "super1" <superbrownbrown1@xxxxxxxxxxxxx>
Subject: Re: MOSS and move SQL database
Date: Thu, 5 Jul 2007 11:22:23 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

These are some excellent directions and seem to be just what I need.
Thanks
a ton. I have hit a snag though...

The service SQL Server 2005 Embedded Edition is not listed in the services.
There are several entries for SQL though. (I am sure it is using the
express edition that comes with MOSS 07.)

On a test server I did the following.
sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E

I get the error

HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
establi
shing a connection to the server. When connecting to SQL Server 2005, this
failu
re may be caused by the fact that under the default settings SQL Server
does
not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.


When I look at the SQL Server Configuration Manager I see the name
OFFICESERVERS. Should I reference that in the command listed above?

Thanks again.

.

Relevant Pages

  • Re: Using SQLCMD to test Connection
    ... Assuming you really execute the batch file from the operating system command interpreter, then you should now have some other error compared to the one you posted earlier. ... Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. ... SQLCMD is not a SQL command, ...
    (microsoft.public.sqlserver.clients)
  • Re: MOSS and move SQL database
    ... sqlcmd -E -S .\SQLEXPRESS,1709 ... SQL Server 2005 Express Edition and SQL ... Server 2005 Developer Edition do not allow remote connections. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: smo create database object
    ... method to create a new sql server database with sql server 2005 ... I've tried the surface area configuration tool, but the database ... When you run the Surface Area Configuration, ... Set it to accept local and remote connections. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: smo create database object
    ... to create a new sql server database with sql server 2005 express? ... I've tried the surface area configuration tool, but the database engine ... When you run the Surface Area Configuration, ... Set it to accept local and remote connections. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Can I Upgrade
    ... Developer Edition of SQL Server can not be used as a production server. ... technically you can (even though I don't really remember technically if you can upgrade from MSDE 2000 to Developer Edition 2000); however it's against the license agreement. ... And here I'm making a list from start to end to install and configure MSDE for remote connections: ...
    (microsoft.public.sqlserver.setup)