SQL Server 2008/aspnet_regsql problem

  • Thread starter Thread starter usfinecats
  • Start date Start date
U

usfinecats

Using this command, I get error
C:\WINDOWS>c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe
-A all -C "Data Source=np:\\VISTA64\pipe\sql\query; Application Name='\';
Initial Catalog=ASPNETMembershipDB; Integrated Security=SSPI;
Password=SQLAgent; User ID=SQLAgent;"

I've verified using PipeList that sql\query is on the VISTA64 machine.
Using SQL Server 2008. on 64 bit vista. trying to hookup client.

I've verified that the ports exist and are enabled on the client (XP sp3)
machine by enabling logging on the the communication on these ports. (on
both Client and Server).

I've created the ASPNETMembershipDB database and SQLAgent has all the rights
in the world. Is there a problem with the string?

Minor jiggering of the string has produced errors 40 , 25, 26 , I just don't
know where to turn next.

TIA.
 
And for the very dense among us all, prey tell what that command string for
aspnet_regsql might be inorder to connect to SQL server on a differnet
computer on my workstation group?

--
Gak -
Finecats


Cor Ligthert said:
SQL server is a server itself, it should not need extras to connect that,
can you try a normal connection string.

www.connectionstrings.com

Cor
Click to expand...
 
It is very simple, as it's IP address is not visible, it is not usable.

Cor

usfinecats said:
And for the very dense among us all, prey tell what that command string
for
aspnet_regsql might be inorder to connect to SQL server on a differnet
computer on my workstation group?
Click to expand...
 
Hi Gak,

As for the aspnet_regsql.exe, you can simply use the "-S" option to specify
the remote SQL Server instance name(instead of specify the entire
connectionstring). The server instance name is just the normal
"computername\instanceName" syntax. e.g.

"myServer2k3\sql2008Inst"

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

Here is a walkthrough on using this tool:

http://www.shiningstar.net/ASPNet_Articles/SqlMembershipProvider.aspx

Btw, as other members mentioned, you need to make sure the remote SQL
server instance has correctly configured to allow remote connection. You
can also trying connecting the server via SQL management studio if
available on the box.

For configuring 2008 for remote connection, here is an article you can
refer to

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-200
8-express/

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.
 
Hi Gak,

Any progress on this issue, have you been able to connect that remote SQL
instance?

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

--------------------
 
Back
Top