Problems installing MSDE

Hi

I've recently downloaded and installed MSDE. I used the instructions from the Microsoft website that makes it as an instance of VSDOTNET. When I rebooted after installing it, there was absolutely no service for the SQL Server Service Manager to do anything with - the icon was in my tray with a blank circle, not a green Play or a red Stop symbol. So I uninstalled it, with an aim to reinstalling it as I had done before - without specifying an instance name.

Only trouble is, I'm now trying to reinstall it using:

setup SAPWD=<pword> SecurityMode=SQL

and I'm getting an error message that says "Setup failed to configure the server. Refer to the serveer error logs and setup error logs for more information." when the progress bar is about 2-thirds of the way along. It does this when I try to install as an instance of VSDOTNET again. It just won't play, and I don't know how to get at the logs to see what's up.

I'm running Win2K SP3, with .NET 1.1. Anyone able to help me?

Thanks
JonCheck to see if you are installing SP3a. If so include the DISABLENETPROTOCOLS=0 in the setup command line. This will ensure that you have enabled the network protocols for a new install. You also don't have to create an instance at installation time.sql

Problems deploying website

My ASP.NET application runs fine within the VS2005 IDE; but, when I deploy to my local machine to try to run it under IIS and calling it up in a browser, I'm getting the following exception:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92
System.Web.UI.WebControls.ListControl.PerformSelect() +31
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

I'm a novice at this and really need some help. What stupid newbie mistake am I making here? Thanks in advance for any guidance/assistance rendered.

When you deplyed the app you left the same SQL trusted connection, and most probably there is no local SQL server running in the same machine. Make sure to change the SQL string to the IP, username and password of the database and will work really well

Al

|||

I remember I got this problem too when I did my first try. It seems that your are using trusted connection, you need assign the domain user in your database with appropriate access right. Or you can create a database user in the database to use standard User/password connection method in your database is in mixed mode..

You can easily find the syntax for the connection string. As to create user in database, you need to create a login account under Security on the Server, in the database, you assign this user for access under database security tab.

Limno

Problems Connecting to MS SQL Server

After a new installation of MS Enterprise SQL Server, i am unable to connect
to the database from a website, and i dont know if MS SQL is working at all.
All the startup services and SQL services are started.Here is the website
that im trying to access my SQL server:
http://www.techparts.org/scripts/install.php
The error message is: Warning: mysql_connect(): Can't connect to MySQL
server on '10.10.8.6' (10061)
Here are the logistics:
The database name is “master” and I just reset the password for “db_we
bsite”
to “database”
Username: db_website
Password: database
Database: master
Host: 10.10.8.6 (MAIN)
Website: http://www.techparts.org/scripts/install.php
Forwarded Ports: 1433 and 3306 to 10.10.8.6
Firewall: No firewall on server or router
Software: MS SQL enterprise server, PHP, and SBS 2003
Permissions: db_website has full permissions to the master database
Authentication: db_website has full permissions to root and subfolders for
the website.
Is there something that im missing on the intial setup of SQL, and why cant
i login?You are trying to connect to MySQL. I'm not sure what
exactly you installed but it looks like you are confusing
Microsoft SQL Server and MySQL. They are two different
products.
For mysql questions, try posting to:
comp.databases.mysql
-Sue
On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
<TechParts@.discussions.microsoft.com> wrote:

>After a new installation of MS Enterprise SQL Server, i am unable to connec
t
>to the database from a website, and i dont know if MS SQL is working at all
.
>All the startup services and SQL services are started.Here is the website
>that im trying to access my SQL server:
>http://www.techparts.org/scripts/install.php
>The error message is: Warning: mysql_connect(): Can't connect to MySQL
>server on '10.10.8.6' (10061)
>Here are the logistics:
>The database name is master and I just reset the password for db_website
>to database
>Username: db_website
>Password: database
>Database: master
>Host: 10.10.8.6 (MAIN)
>Website: http://www.techparts.org/scripts/install.php
>Forwarded Ports: 1433 and 3306 to 10.10.8.6
>Firewall: No firewall on server or router
>Software: MS SQL enterprise server, PHP, and SBS 2003
>Permissions: db_website has full permissions to the master database
>Authentication: db_website has full permissions to root and subfolders for
>the website.
>Is there something that im missing on the intial setup of SQL, and why cant
>i login?|||I assume what you're doing is trying to connect to SQL Server from PHP?
Chances are the connection string will be different for SQL Server than it
is for mysql so you may want to look at the connection string that is
actually used for the connection to see if it follows the SQL Server
conventions. ODBC queries are pretty standard but the connections string
aren't always. There may be information on the php site on how to do this -
or maybe someone here has done it successfully.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:6als42do2hrecr933a16k2f22mo2iuo91b@.
4ax.com...
> You are trying to connect to MySQL. I'm not sure what
> exactly you installed but it looks like you are confusing
> Microsoft SQL Server and MySQL. They are two different
> products.
> For mysql questions, try posting to:
> comp.databases.mysql
> -Sue
> On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
> <TechParts@.discussions.microsoft.com> wrote:
>
>|||Hi,
After this is over, you may want to change the password to the database and
never give it out again in a public newsgroup.
Nathan H. Omukwenyi
"Tech Parts" <TechParts@.discussions.microsoft.com> wrote in message
news:73123C3F-FD8F-463D-9E0C-9B54A1F395F0@.microsoft.com...
> After a new installation of MS Enterprise SQL Server, i am unable to
> connect
> to the database from a website, and i dont know if MS SQL is working at
> all.
> All the startup services and SQL services are started.Here is the website
> that im trying to access my SQL server:
> http://www.techparts.org/scripts/install.php
> The error message is: Warning: mysql_connect(): Can't connect to MySQL
> server on '10.10.8.6' (10061)
> Here are the logistics:
> The database name is "master" and I just reset the password for
> "db_website"
> to "database"
> Username: db_website
> Password: database
> Database: master
> Host: 10.10.8.6 (MAIN)
> Website: http://www.techparts.org/scripts/install.php
> Forwarded Ports: 1433 and 3306 to 10.10.8.6
> Firewall: No firewall on server or router
> Software: MS SQL enterprise server, PHP, and SBS 2003
> Permissions: db_website has full permissions to the master database
> Authentication: db_website has full permissions to root and subfolders for
> the website.
> Is there something that im missing on the intial setup of SQL, and why
> cant
> i login?
>

Problems acessing the database after creating a website on localhost

I cannot access the data source when I create a website in express - when I try to connect to the database I get an error telling that I am unable to connect to the data source - I tried doing it through the Visual Studio and through the Web Configaration.

Can some please help - I need to conncet!!!

What the connction string and the exact error message ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

"Failed to generate a user instance of SQL Server due to failure in starting the process for the user instance. The connection will be closed"

This is the error messgae that I get when I try to connect to the data source.

Can you help?

|||Do you have SQL Server Express installed ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Reese C. M. Harris wrote:

"Failed to generate a user instance of SQL Server due to failure in starting the process for the user instance. The connection will be closed"

This is the error messgae that I get when I try to connect to the data source.

Can you help?

This is a known issue and the solution is the one posted by user Reen in the long thread below. Hope this helps.

http://forums.microsoft.com/msdn/showpost.aspx?postid=293667&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0

Problem with Website and SQL database synchronization

We have one web server, which is running on Win2K server,
MS-SQL and Sharepoint. Last week it went down and i found
this error message "The list or view of a list that is
referenced here no longer exists".
Kindly help us.
"The list or view of a list that is referenced here no
longer exists".
Found this error message where? Your application? SQL Server logs?
Windows Event Viewer? Something in sharepoint?
I've never seen that message before, but if you can give us better context
(where the error came from, I'm suspecting SharePoint), as well as anything
abnormal that might have been happening on the box around the same time as
the error message (e.g. backup, restore, DTS, log shipping, long-running
job, high volume).
And also the symptom of the problem -- is the problem that there is an error
message, or is something else going wrong with the application that you are
attributing to the error message?
Is it possible that a table or view in Sharepoint became corrupt? Does
Sharepoint have any repair or self-healing tasks you can run? Not being
familiar with Sharepoint, I recommend that you pursue this in a Sharepoint
newsgroup (microsoft.public.sharepoint.teamservices) where you will be much
more likely to find Sharepoint experts with direct experience with this
problem, or at least a better knowledge base to help you out.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Srichandan T." <srichandan.tirumalai@.wipro.com> wrote in message
news:9f1601c43454$cc4b4a40$a501280a@.phx.gbl...
> We have one web server, which is running on Win2K server,
> MS-SQL and Sharepoint. Last week it went down and i found
> this error message "The list or view of a list that is
> referenced here no longer exists".
> Kindly help us.
>
> "The list or view of a list that is referenced here no
> longer exists".

Problem with Website and SQL database synchronization

We have one web server, which is running on Win2K server,
MS-SQL and Sharepoint. Last week it went down and i found
this error message "The list or view of a list that is
referenced here no longer exists".
Kindly help us.
"The list or view of a list that is referenced here no
longer exists".Found this error message where? Your application? SQL Server logs?
Windows Event Viewer? Something in sharepoint?
I've never seen that message before, but if you can give us better context
(where the error came from, I'm suspecting SharePoint), as well as anything
abnormal that might have been happening on the box around the same time as
the error message (e.g. backup, restore, DTS, log shipping, long-running
job, high volume).
And also the symptom of the problem -- is the problem that there is an error
message, or is something else going wrong with the application that you are
attributing to the error message?
Is it possible that a table or view in Sharepoint became corrupt? Does
Sharepoint have any repair or self-healing tasks you can run? Not being
familiar with Sharepoint, I recommend that you pursue this in a Sharepoint
newsgroup (microsoft.public.sharepoint.teamservices) where you will be much
more likely to find Sharepoint experts with direct experience with this
problem, or at least a better knowledge base to help you out.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Srichandan T." <srichandan.tirumalai@.wipro.com> wrote in message
news:9f1601c43454$cc4b4a40$a501280a@.phx.gbl...
> We have one web server, which is running on Win2K server,
> MS-SQL and Sharepoint. Last week it went down and i found
> this error message "The list or view of a list that is
> referenced here no longer exists".
> Kindly help us.
>
> "The list or view of a list that is referenced here no
> longer exists".

Problem with Website and SQL database synchronization

We have one web server, which is running on Win2K server,
MS-SQL and Sharepoint. Last week it went down and i found
this error message "The list or view of a list that is
referenced here no longer exists".
Kindly help us.
"The list or view of a list that is referenced here no
longer exists".Found this error message where? Your application? SQL Server logs?
Windows Event Viewer? Something in sharepoint?
I've never seen that message before, but if you can give us better context
(where the error came from, I'm suspecting SharePoint), as well as anything
abnormal that might have been happening on the box around the same time as
the error message (e.g. backup, restore, DTS, log shipping, long-running
job, high volume).
And also the symptom of the problem -- is the problem that there is an error
message, or is something else going wrong with the application that you are
attributing to the error message?
Is it possible that a table or view in Sharepoint became corrupt? Does
Sharepoint have any repair or self-healing tasks you can run? Not being
familiar with Sharepoint, I recommend that you pursue this in a Sharepoint
newsgroup (microsoft.public.sharepoint.teamservices) where you will be much
more likely to find Sharepoint experts with direct experience with this
problem, or at least a better knowledge base to help you out.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Srichandan T." <srichandan.tirumalai@.wipro.com> wrote in message
news:9f1601c43454$cc4b4a40$a501280a@.phx.gbl...
> We have one web server, which is running on Win2K server,
> MS-SQL and Sharepoint. Last week it went down and i found
> this error message "The list or view of a list that is
> referenced here no longer exists".
> Kindly help us.
>
> "The list or view of a list that is referenced here no
> longer exists".

Problem with Website and SQL Data base synchronization

Problem with Website and SQL synchronization
We have one web server, which is running on Win2K server,
MS-SQL and Sharepoint. Last week it went down and i found
this error message "The list or view of a list that is
referenced here no longer exists".
Kindly help us.
"The list or view of a list that is referenced here no
longer exists".
I'm almost certain that error message was not generated by SQL Server. Where does the error appear? Try using SQL Profiler to see whether the sql box does actually generate an error.
Alicia
saw this http://www.sqlporn.co.uk - made me laugh anyway!

Problem with Website and SQL Data base synchronization

Problem with Website and SQL synchronization
We have one web server, which is running on Win2K server,
MS-SQL and Sharepoint. Last week it went down and i found
this error message "The list or view of a list that is
referenced here no longer exists".
Kindly help us.
"The list or view of a list that is referenced here no
longer exists".I'm almost certain that error message was not generated by SQL Server. Where
does the error appear? Try using SQL Profiler to see whether the sql box do
es actually generate an error.
Alicia
saw this http://www.sqlporn.co.uk - made me laugh anyway!

Problem with website and db

I am new to .NET and the Visual Web Developer Express and what not...I have created a website on my machine which works wonderfully...however, and I'm sure this is somewhere but I can't find it, I cannot get it to work on my host server...the Default page comes up, but when I try to sign in it says:

"An attempt to attach an auto-named database for file c:\hosting\webhost4life\member\harrison0801\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."

The host support tells me to change the db name from aspnetdb to something else...I do this and when I run the site again or try to log in, I get the exact same error message...then they go on to tell me that I have to remove the LocalSqlServer in the web.config file which now looks like this:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|aspnetdb.mdf;User instance=true;" providerName="System.Data.SqlClient" />

<add name="Example" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|example.mdf;User instance=true;Initial Catalog=example;" providerName="System.Data.SqlClient" />

</connectionStrings>

Of course this isn't working either...otherwise I would off playing on my server, and not posting here. Also, when I set up all the roles, users, and what not on my machine...does this carry over to the host machine?

Desperately needing massive help here...

Not a DBA and no expert in .NET

Thank you very much in advance,

Darren

Rename the .mdf file from aspnetdb.mdf to harrison0801.mdf and change your connection string to

<add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|harrison0801.mdf;User instance=true;" providerName="System.Data.SqlClient" />

|||

Okay...renamed the ASPNETDB.MDF and changed the config connection string to the above...hit CTRL F5 to run it...and guess what magically appeared? ASPNETDB without regard to the one I just changed the name on.

Also, when I run the ASP NET Configuration utililty in the VWD...walks me through all the roles, users, etc...it loads all that info into the ASPNETDB...is there something in the default config for the DB creator that can be changed? Perhaps this is something that the ASPNET creators can work out...maybe like allow the developers to name there own DB in the process of creating websites? Would be nice...less of a headache.