Problems with transactional replication without making a snapshot

I try to configure replication between 2 SQL Server 2000 servers with another
SQL Server 2000 machine configured as the distributor. (All with SP3)
I initialize the replication with 'subscribers already has the data schema
en the data'
and I use pull subscription.
When I have finished the replication setup the next error occurred on the
Distribution agent:
Violation of PRIMARY KEY constraint 'PK__@.snapshot_seqnos__0169315C'. Cannot
insert duplicate key in object '#00750D23'.
I've disabled the whole replication and reboot the servers but the error
still appears.
What could be the reason of the problem I’ve defined?
have a look at this kb article:
http://support.microsoft.com/default...b;en-us;813494
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Marijn" <Marijn@.discussions.microsoft.com> wrote in message
news:AE46BE44-3E53-4CD2-ADF4-9D01EE86BDF3@.microsoft.com...
>I try to configure replication between 2 SQL Server 2000 servers with
>another
> SQL Server 2000 machine configured as the distributor. (All with SP3)
> I initialize the replication with 'subscribers already has the data schema
> en the data'
> and I use pull subscription.
> When I have finished the replication setup the next error occurred on the
> Distribution agent:
> Violation of PRIMARY KEY constraint 'PK__@.snapshot_seqnos__0169315C'.
> Cannot
> insert duplicate key in object '#00750D23'.
> I've disabled the whole replication and reboot the servers but the error
> still appears.
> What could be the reason of the problem I've defined?
>
>

problems with SQLDMO.dll

i have a vb.net application that uses SQL-DMO. the development machine is
WinXP
when i build a setup for my application and then install this on a clean
WinXP test machine it all runs fine
but when i install it on a Win2000 test machine i get the following error -
the sqldmo.dll registers successfully - but just gives this error message.
[SQL-DMO]Invalid Paramter Type; must be string or ordinal......
i have followed all the instructions thru here:-
http://support.microsoft.com/default.aspx?scid=kb;en-us;248241
but still cannot get it to run. any ideas as to what may be causing this? is
there different versions of sqldmo.dll that i need to run for win2k?
Cheers,
Craighi Craig,
"Craig G" <craig.gamble@.yarrasoftware.com> ha scritto nel messaggio
news:%23lsbQskmEHA.3340@.TK2MSFTNGP14.phx.gbl...
> i have a vb.net application that uses SQL-DMO. the development machine is
> WinXP
> when i build a setup for my application and then install this on a clean
> WinXP test machine it all runs fine
> but when i install it on a Win2000 test machine i get the following
error -
> the sqldmo.dll registers successfully - but just gives this error message.
> [SQL-DMO]Invalid Paramter Type; must be string or ordinal......
> i have followed all the instructions thru here:-
> http://support.microsoft.com/default.aspx?scid=kb;en-us;248241
> but still cannot get it to run. any ideas as to what may be causing this?
is
> there different versions of sqldmo.dll that i need to run for win2k?
actually not that I'm aware of...
personally I've built my (InnoSetup) SQL-DMO install package on a WinXP sp1
box, and deployed with success on Win98, Win2k, XP and Win2003..
the list of files I ditribute is like following:
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\odbcbcp.dll; DestDir: WinSys ; sharedfile
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\sqlwoa.dll ; DestDir: WinSys
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\sqlwid.dll ; DestDir: WinSys
..\Programmi\Microsoft SQL Server\80\Tools\Binn\w95scm.dll; DestDir:
DestinationFolder\Binn
..\WINDOWS\SYSTEM\sqlunirl.dll ; DestDir: WinSys
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlresld.dll; DestDir:
DestinationFolder\Binn
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlsvc.dll; DestDir:
DestinationFolder\Binn
; not licensed by redist.txt but available after installation of MDAC2.6
..\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlsvc.RLL;
DestDir: DestinationFolder\Binn\Resources\1033
; not licensed by redist.txt but available after installation of MDAC2.6
..\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Sqldmo.rll;
DestDir: DestinationFolder\Binn\Resources\1033
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll; DestDir:
DestinationFolder\Binn ; file to be registered via regserver
DestinationFolder can either be the installation directory of one instance
of Microsoft SqlServer 2000, like ..\Program Files\Microsoft SQL
Server\80\Tools, even if no istance of SQL Server has been installed, or the
installation directory of your application, but the first is preferred.
Please do respect the hierarchy \Binn\Resources\1033 (where 1033 specifies
the language), where needed, in order to grant correct functionality of
Ole-Automation objects.
In order to install SQL-DMO components for MSDE 2000, Microsoft Internet
Explorer 5.5 or higher is required.
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

problems with SQLDMO.dll

i have a vb.net application that uses SQL-DMO. the development machine is
WinXP
when i build a setup for my application and then install this on a clean
WinXP test machine it all runs fine
but when i install it on a Win2000 test machine i get the following error -
the sqldmo.dll registers successfully - but just gives this error message.
[SQL-DMO]Invalid Paramter Type; must be string or ordinal......
i have followed all the instructions thru here:-
http://support.microsoft.com/default...b;en-us;248241
but still cannot get it to run. any ideas as to what may be causing this? is
there different versions of sqldmo.dll that i need to run for win2k?
Cheers,
Craig
Craig,
You may to make sure the your Windows 2000 machine is on the same version of
..NET as was your XP machine.
Regards,
Cory
"Craig G" wrote:

> i have a vb.net application that uses SQL-DMO. the development machine is
> WinXP
> when i build a setup for my application and then install this on a clean
> WinXP test machine it all runs fine
> but when i install it on a Win2000 test machine i get the following error -
> the sqldmo.dll registers successfully - but just gives this error message.
> [SQL-DMO]Invalid Paramter Type; must be string or ordinal......
> i have followed all the instructions thru here:-
> http://support.microsoft.com/default...b;en-us;248241
> but still cannot get it to run. any ideas as to what may be causing this? is
> there different versions of sqldmo.dll that i need to run for win2k?
> Cheers,
> Craig
>
>

Problems with SQL Installation when certificate is installed

Hi,
I am trying to setup SQL Server on a machine with a certificate. During the
installation I get the following error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security e
rror
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(SECDoClientHandshake()).
SQL Server configuration failed.
Now, I know that this is a problem with SQL Server and has been documented
in KB309398
http://support.microsoft.com/defaul...kb;EN-US;309398
But the solution that it suggests involves removing of the certificate and
then installing SQL and Service pack.
The certificate that I have installed has a private key and cannot be fully
exported to a file.
So I cannot delete the certificate.
Is there any alternative way to disable certificates during installation or
any way of installing SQL on a machine with a certificate.
Thanks in advanceAre you running SQL 2000 sp3?
Use the Client Network Utility and Disable or Uncheck Shared Memory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Problems with SQL 2000 and 2005 on same machine - Can't connect on 2000

Hi,
i have SQL 2000 and 2005 on same machine(with different intance names,
of course), my laptop - XP with SP2. The 2005 works fine but i can't
connect on SQL 2000. All the the SQL services are started.
Any idea? Have i to reinstall 2000?
Tks,
LourivalAre both named instances or is one for them default instance and if so, whic
h is the default
instance? Is the SQL Server browser service started?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<lourivalsjr@.gmail.com> wrote in message
news:1142254900.463560.180690@.e56g2000cwe.googlegroups.com...
> Hi,
> i have SQL 2000 and 2005 on same machine(with different intance names,
> of course), my laptop - XP with SP2. The 2005 works fine but i can't
> connect on SQL 2000. All the the SQL services are started.
> Any idea? Have i to reinstall 2000?
> Tks,
> Lourival
>|||one of then is the default instance, the 2000. The 2005 instance is
named.
tks,
Tibor|||So what error do you get when you run the following from a command prompt
osql -E -S (local)
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<lourivalsjr@.gmail.com> wrote in message
news:1142270454.932906.302490@.j33g2000cwa.googlegroups.com...
> one of then is the default instance, the 2000. The 2005 instance is
> named.
> tks,
> Tibor
>|||No error. It just became freezed. It=B4s the same for enterprise manager
or any app that try to connect.
regards,
Lourival|||OK, I thought it might be the SQL Browser service not started, but that shou
ld mean you can connect
to the default but not named. You seem to have the other way around. One mor
e thing you can check is
the netlib configuration. Except for that, I'm out of ideas, I'm afraid.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<lourivalsjr@.gmail.com> wrote in message
news:1142270454.932906.302490@.j33g2000cwa.googlegroups.com...
> one of then is the default instance, the 2000. The 2005 instance is
> named.
> tks,
> Tibor
>sql

Problems with SQL 2000 and 2005 on same machine - Can't connect on 2000

Hi,
i have SQL 2000 and 2005 on same machine(with different intance names,
of course), my laptop - XP with SP2. The 2005 works fine but i can't
connect on SQL 2000. All the the SQL services are started.
Any idea? Have i to reinstall 2000?
Tks,
LourivalAre both named instances or is one for them default instance and if so, which is the default
instance? Is the SQL Server browser service started?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<lourivalsjr@.gmail.com> wrote in message
news:1142254900.463560.180690@.e56g2000cwe.googlegroups.com...
> Hi,
> i have SQL 2000 and 2005 on same machine(with different intance names,
> of course), my laptop - XP with SP2. The 2005 works fine but i can't
> connect on SQL 2000. All the the SQL services are started.
> Any idea? Have i to reinstall 2000?
> Tks,
> Lourival
>|||one of then is the default instance, the 2000. The 2005 instance is
named.
tks,
Tibor|||So what error do you get when you run the following from a command prompt
osql -E -S (local)
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<lourivalsjr@.gmail.com> wrote in message
news:1142270454.932906.302490@.j33g2000cwa.googlegroups.com...
> one of then is the default instance, the 2000. The 2005 instance is
> named.
> tks,
> Tibor
>|||No error. It just became freezed. It=B4s the same for enterprise manager
or any app that try to connect.
regards,
Lourival|||OK, I thought it might be the SQL Browser service not started, but that should mean you can connect
to the default but not named. You seem to have the other way around. One more thing you can check is
the netlib configuration. Except for that, I'm out of ideas, I'm afraid.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<lourivalsjr@.gmail.com> wrote in message
news:1142270454.932906.302490@.j33g2000cwa.googlegroups.com...
> one of then is the default instance, the 2000. The 2005 instance is
> named.
> tks,
> Tibor
>

Problems with SQL 2000 and 2005 on same machine - Can't connect on 2000

Hi,
i have SQL 2000 and 2005 on same machine(with different intance names,
of course), my laptop - XP with SP2. The 2005 works fine but i can't
connect on SQL 2000. All the the SQL services are started.
Any idea? Have i to reinstall 2000?
Tks,
Lourival
Are both named instances or is one for them default instance and if so, which is the default
instance? Is the SQL Server browser service started?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<lourivalsjr@.gmail.com> wrote in message
news:1142254900.463560.180690@.e56g2000cwe.googlegr oups.com...
> Hi,
> i have SQL 2000 and 2005 on same machine(with different intance names,
> of course), my laptop - XP with SP2. The 2005 works fine but i can't
> connect on SQL 2000. All the the SQL services are started.
> Any idea? Have i to reinstall 2000?
> Tks,
> Lourival
>
|||one of then is the default instance, the 2000. The 2005 instance is
named.
tks,
Tibor
|||So what error do you get when you run the following from a command prompt
osql -E -S (local)
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<lourivalsjr@.gmail.com> wrote in message
news:1142270454.932906.302490@.j33g2000cwa.googlegr oups.com...
> one of then is the default instance, the 2000. The 2005 instance is
> named.
> tks,
> Tibor
>
|||No error. It just became freezed. It=B4s the same for enterprise manager
or any app that try to connect.
regards,
Lourival
|||OK, I thought it might be the SQL Browser service not started, but that should mean you can connect
to the default but not named. You seem to have the other way around. One more thing you can check is
the netlib configuration. Except for that, I'm out of ideas, I'm afraid.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<lourivalsjr@.gmail.com> wrote in message
news:1142270454.932906.302490@.j33g2000cwa.googlegr oups.com...
> one of then is the default instance, the 2000. The 2005 instance is
> named.
> tks,
> Tibor
>

Problems with SQL 2000 and 2005 on same machine - Cant connect on 2000

Hi,
i have SQL 2000 and 2005 on same machine(with different intance names,
of course), my laptop - XP with SP2. The 2005 works fine but i can't
connect on SQL 2000. All the the SQL services are started.

Any idea? Have i to reinstall 2000?

Tks,
Lourival(lourivalsjr@.gmail.com) writes:
> i have SQL 2000 and 2005 on same machine(with different intance names,
> of course), my laptop - XP with SP2. The 2005 works fine but i can't
> connect on SQL 2000. All the the SQL services are started.
> Any idea? Have i to reinstall 2000?

Exactly which service-pack level of SQL 2000 do you have? You can view
this on the first line of
C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG
(if this is the instance directory for SQL 2000.)

I believe you need at least SP3 (8.00.760 to run in parallel with SQL 2005.)

Another thing to try is to open the Server and Client Network Utilities of
SQL 2000, and make sure that both use TCP/IP. For local connections,
shared memory is the default, but if it for some reason does not work, you
can try TCP/IP.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Problems with debugging remotely SQLCLR stored procedures?

Hello,

my username is se\levalencia, I had before the database on my machine, but as now we have a server I backed up the database and restored on the server, it seems that it has the sames logins and security users,

Its strange because the user dbo is assigned the user se\levalencia on the server, and I cant alter the user dbo.

The user dbo should be the login sa? I am in big trouble with this, beacuase I cant debug my sql clr stored procedure.

T-Sql execution ended without debugging. You may have not have sufficient permissions to debug.

I am using a connection with windows authentication, so it means that its sending tha tokes as se\levalencia to the server.

Please feel free to ask for more information about it. Thanks

More strange yet, I just changed the connection and put SA as the user which executes the sql clr stored procedure, I got the same problem, its supposed to be a super user.

|||

You would need to add se\levalencia as a member of sysadmin role on the server. For debugging T-SQL as well as SQLCLR the debugger needs to run under an account that is a member of sysadmin role on SQL Server.

Thanks,

-Vineet.

Problems with debugging remotely SQLCLR stored procedures?

Hello,

my username is se\levalencia, I had before the database on my machine, but as now we have a server I backed up the database and restored on the server, it seems that it has the sames logins and security users,

Its strange because the user dbo is assigned the user se\levalencia on the server, and I cant alter the user dbo.

The user dbo should be the login sa? I am in big trouble with this, beacuase I cant debug my sql clr stored procedure.

T-Sql execution ended without debugging. You may have not have sufficient permissions to debug.

I am using a connection with windows authentication, so it means that its sending tha tokes as se\levalencia to the server.

Please feel free to ask for more information about it. Thanks

More strange yet, I just changed the connection and put SA as the user which executes the sql clr stored procedure, I got the same problem, its supposed to be a super user.

|||

You would need to add se\levalencia as a member of sysadmin role on the server. For debugging T-SQL as well as SQLCLR the debugger needs to run under an account that is a member of sysadmin role on SQL Server.

Thanks,

-Vineet.

Problems with Create Endpoint

I'm on XP running SQL 2005 (9.0.1314) trying to create and endpoint on my local machine.

I'm trying to run the Adventureworks sample code:

CREATE PROCEDURE [dbo].[uspGetPersonInfo]

@.ID [int]

AS

BEGIN

SET NOCOUNT ON;

SELECT [FirstName],[MiddleName],[LastName]

FROM [AdventureWorks].[Person].[Contact]

WHERE ContactID = @.ID

END;

CREATE ENDPOINT SQLEP_AWPersons

STATE = STARTED

AS HTTP

(

PATH = '/AWpersons',

AUTHENTICATION = (INTEGRATED),

PORTS = (CLEAR),

SITE = '*'

)

FOR SOAP

(

WEBMETHOD 'PersonInfo'

(NAME='AdventureWorks.dbo.uspGetPersonInfo', FORMAT=ROWSETS_ONLY, schema=STANDARD),

BATCHES = DISABLED,

WSDL = DEFAULT,

DATABASE = 'AdventureWorks',

NAMESPACE = 'http://Adventure-Works/Persons'

)
I get the following error message:

Msg 7890, Level 16, State 1, Line 1

An error occurred while attempting to register the endpoint 'SQLEP_AWPersons'. One or more of the ports specified in the CREATE ENDPOINT statement may be bound to another process. Attempt the statement again with a different port or use netstat to find the application currently using the port and resolve the conflict.

I did run netstat but since I am using Ports(Clear) I'm not sure what port could be giving the conflict.

Thanks for any help on this matter.

Did you get this sorted ?
I am having exactly the same problem...
|||Try

http://www.cubido.at/Blog/tabid/176/EntryID/36/Default.aspx
|||Did you checked netstat or httpcfg.exe for that ?

HTH, Jens Suessmeyer.

Problems with Create Endpoint

I'm on XP running SQL 2005 (9.0.1314) trying to create and endpoint on my local machine.

I'm trying to run the Adventureworks sample code:

CREATE PROCEDURE [dbo].[uspGetPersonInfo]

@.ID [int]

AS

BEGIN

SET NOCOUNT ON;

SELECT [FirstName],[MiddleName],[LastName]

FROM [AdventureWorks].[Person].[Contact]

WHERE ContactID = @.ID

END;

CREATE ENDPOINT SQLEP_AWPersons

STATE = STARTED

AS HTTP

(

PATH = '/AWpersons',

AUTHENTICATION = (INTEGRATED),

PORTS = (CLEAR),

SITE = '*'

)

FOR SOAP

(

WEBMETHOD 'PersonInfo'

(NAME='AdventureWorks.dbo.uspGetPersonInfo', FORMAT=ROWSETS_ONLY, schema=STANDARD),

BATCHES = DISABLED,

WSDL = DEFAULT,

DATABASE = 'AdventureWorks',

NAMESPACE = 'http://Adventure-Works/Persons'

)
I get the following error message:

Msg 7890, Level 16, State 1, Line 1

An error occurred while attempting to register the endpoint 'SQLEP_AWPersons'. One or more of the ports specified in the CREATE ENDPOINT statement may be bound to another process. Attempt the statement again with a different port or use netstat to find the application currently using the port and resolve the conflict.

I did run netstat but since I am using Ports(Clear) I'm not sure what port could be giving the conflict.

Thanks for any help on this matter.

Did you get this sorted ?
I am having exactly the same problem...|||Try

http://www.cubido.at/Blog/tabid/176/EntryID/36/Default.aspx|||Did you checked netstat or httpcfg.exe for that ?

HTH, Jens Suessmeyer.

Problems when Oracle running on same machine

I was deploying my Report Model in Visual Studio but got an error that it couldnt connect to my Report Server while it was running.

When i typed the address of my ReportServer I got an error, then when I typed the name of the localhost got an Oracle screen. So then I decided to turn off all the Oracle things running on the machine. Then when I tried to deploy again it worked and I could go to my ReportServer without problems.

I assume you aren't trying to build a Report Model on top of Oracle, it just happens to be running. The only thing I can think is that Oracle is taking over the HTTP port configured for Reporting Services.|||I think this is the reason as well, I just wanted to point this out to other users that they should look at this when they cannot connect to their ReportServer when Oracle is running. Is there a way that I can give preference to Microsoft instead of Oracle ?|||I'm not very familiar with Oracle's HTTP stack. You don't mention which version of Oracle you are using but 10g comes with a modified version of Apache called OHS. I think there are configurations where you can tell it to listen on a port not managed by IIS.|||<a href= http://voip-forum.tmcnet.com/forum/forum_posts.asp?TID=55428&PN=1&TPN=1 >Enter here</a>

Problems using SQL 2005

I'm going to move this onto a server with SQL 2005 installed. I also happen to have SQL 2005 installed on my home machine, so it seems silly to me to install SQL Express.

I'm following the

Video Series: Visual Web Developer for Beginners video to use login controls. I click on Website-> ASP.NET Configuration, then on the Security tab. I get the following message: "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the buttom below to be redirected to a page where you can choose a new data store."

"The following message may help in diagnosing the problem: Unable to connect to SQL Server database."

I clicked on the button to choose data store, selected "Select a single provider for all site management data", clicked the radiobutton for AspNetSqlProvider, then clicked test.

I then got 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 did that. I did it with windows authentication, and with SQL server authentication (as the administrator). I did it with the default database, and with one I created. At some point, a new database was created, aspnetdb, but I can't get the setting right, I can't connect to it.

When I run aspnet_regsql, I get the following message: "You should now configure the provider for membership, profiles, role, personalization and SQL Web event provider to reflect the changes you made in this wizard" and so on...

So what could I be doing wrong? How do I configure this for SQL 2005? Also, the database that's created. Can this be used by all the websites I develop? Or do I need a separate database per website? What are my other options besides SQL or SQL Express? Can I use Access? Anything else?

I would appreciate any help you can give me!

More than likely your server won't accept remote connections. Start here:

http://www.teratrax.com/articles/connecting_sql_server_express.html

Buck Woody

|||http://forums.microsoft.com/msdn/ShowPost.aspx?postid=1117787&siteid=1

Problems using SQL 2005

I'm going to move this onto a server with SQL 2005 installed. I also happen to have SQL 2005 installed on my home machine, so it seems silly to me to install SQL Express.

I'm following the

Video Series: Visual Web Developer for Beginners video to use login controls. I click on Website-> ASP.NET Configuration, then on the Security tab. I get the following message: "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the buttom below to be redirected to a page where you can choose a new data store."

"The following message may help in diagnosing the problem: Unable to connect to SQL Server database."

I clicked on the button to choose data store, selected "Select a single provider for all site management data", clicked the radiobutton for AspNetSqlProvider, then clicked test.

I then got 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 did that. I did it with windows authentication, and with SQL server authentication (as the administrator). I did it with the default database, and with one I created. At some point, a new database was created, aspnetdb, but I can't get the setting right, I can't connect to it.

When I run aspnet_regsql, I get the following message: "You should now configure the provider for membership, profiles, role, personalization and SQL Web event provider to reflect the changes you made in this wizard" and so on...

So what could I be doing wrong? How do I configure this for SQL 2005? Also, the database that's created. Can this be used by all the websites I develop? Or do I need a separate database per website? What are my other options besides SQL or SQL Express? Can I use Access? Anything else?

I would appreciate any help you can give me!

More than likely your server won't accept remote connections. Start here:

http://www.teratrax.com/articles/connecting_sql_server_express.html

Buck Woody

|||http://forums.microsoft.com/msdn/ShowPost.aspx?postid=1117787&siteid=1

Problems using SQL 2005

I'm going to move this onto a server with SQL 2005 installed. I also happen to have SQL 2005 installed on my home machine, so it seems silly to me to install SQL Express.

I'm following the

Video Series: Visual Web Developer for Beginners video to use login controls. I click on Website-> ASP.NET Configuration, then on the Security tab. I get the following message: "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the buttom below to be redirected to a page where you can choose a new data store."

"The following message may help in diagnosing the problem: Unable to connect to SQL Server database."

I clicked on the button to choose data store, selected "Select a single provider for all site management data", clicked the radiobutton for AspNetSqlProvider, then clicked test.

I then got 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 did that. I did it with windows authentication, and with SQL server authentication (as the administrator). I did it with the default database, and with one I created. At some point, a new database was created, aspnetdb, but I can't get the setting right, I can't connect to it.

When I run aspnet_regsql, I get the following message: "You should now configure the provider for membership, profiles, role, personalization and SQL Web event provider to reflect the changes you made in this wizard" and so on...

So what could I be doing wrong? How do I configure this for SQL 2005? Also, the database that's created. Can this be used by all the websites I develop? Or do I need a separate database per website? What are my other options besides SQL or SQL Express? Can I use Access? Anything else?

I would appreciate any help you can give me!

More than likely your server won't accept remote connections. Start here:

http://www.teratrax.com/articles/connecting_sql_server_express.html

Buck Woody

|||http://forums.microsoft.com/msdn/ShowPost.aspx?postid=1117787&siteid=1