I dont find any sql server database

Hi,

I installed already vs 2005. The installation installed automaticaly SQL Server 2005 express. Now , I want to see which databases I have there and tables,views,store procedure etc. I tried the server explorer in the vs but I don't see any database on my pc. I tried also to open somthing like enterprise manager like I have in sql server 2000 but I don't found such a tool. I tried to find it in START=>Programs=>SQL Server 2005 but their I see only the Configuration tool. I want to know if the installation of the vs 2005 does not install Databases for the sql server Express ? Should I have to download this database samples? What about a tool to view those database like the enterprise manager in sql server 2000 ?

Thanks,

David

Go to SQL server Express web page and download SQL Management studio express

http://msdn2.microsoft.com/en-us/sql/aa336346.aspx

or

http://msdn.microsoft.com/vstudio/express/sql/download/

It should help. To test you can just create new project in VS and try to create SQL server datasource in it.

Thanks

JPazgier

|||

Hi,

You can install the express edition for Management Studio and you can also configure the SQL Server instance from your Server Explorer. But first, you have to check whether the SQL Server instance has been started.

Here are the steps:

1. Start->Run
2. Enter "services.msc" to start the services window.
3. Find the service named SQL Server. The default name for a SQL Express instance is SQLEXPRESS.
4. If it is not started, start it.

HTH.

|||

Hi JPazgier,

Thanks. It works. I installed the managment sudio but it was with no deafault database so I downloaded also the AdventureWorksDB.msi and installad it. After it, I write this code in the managment studio :

execsp_attach_db @.dbname=N'AdventureWorks', @.filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @.filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'

Now it works.

David

|||

You can aslo do it directly in management studio by right click on Databases and select comand from menu attach database (or something like this).

By the way you always have at least 4 system databases on the server and system use one of them as default if no default database is specified for user.

Good work

JPazgier

i created a login in SQL SERVER 2005 EXPRESS, but cant login...

create login dave with password='abc', default_database=tempdb

when i use this account to login my sql2005, i got

Msg 18452, Level 14, State 1, Server DAVID-398113F7C\SQLEXPRESS, Line 1
Login failed for user 'dave'. The user is not associated with a trusted SQL Serv
er connection.
why?You have probably installed the server such that it only allows Windows Authentication, so you cannot connect with a SQL login.

See the "How to: Change Server Authentication Mode" topic in Books Online for additional information on how to allow SQL authentication.

Thanks
Laurentiu|||follow the How to instruction, on right-click my sql server, i got a error msg. indicating that my server is not correctly registed !

in the reg. properity dialog box, i see my auth. mode is Windows Authentication, is there anything wrong with this ?|||Windows authentication means you can only connect with a Windows login. The login dave that you created is a SQL login, so it will not work if you only enabled Windows authentication. There is nothing wrong here, this is how it works.

However, the error message that you are getting when you right click on your server looks like a problem. You should post to SQL Server Tools General to find out what is wrong. If you cannot get an answer, please open a bug at http://lab.msdn.microsoft.com/productfeedback/Default.aspx.

In the meantime, you can try to change the authentication mode manually by modifying the following registry information to contain value 2 instead of 1:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\LoginMode

1 means Windows authentication, this is the value you should find set. By changing this to 2, you'll set the mixed authentication mode. Be sure to restart the server for this change to take effect.

Thanks
Laurentiu|||thx! i changed the reg key, and it works fine now!

but, still, i cant get the server work, it popup a [SQL-DMO] erros|||Try posting on the SQL Server SMO/DMO forum with the text of the error and a description of the steps you took before you received it. There might be something wrong with your installation though. Have you tried installing on a different machine or reinstalling? Did you get any errors during the initial installation?

Thanks
Laurentiu

I cant Install SQL Server 2005 (final release) in the same machine with SQL Server Express Editi

Hi

I have download SQL Server 2005 evaluation 180 Days from Microsoft web site and install it fine without any problem in my machine

But when I try to install SQL Server Express edition on the same machine I lose many of start menu tools related to SQL Server 2005 Like.

Analysis Services -> Deployment Wizard

(All) Documentation and Tutorials

Performance Tools -> Database Engine Tuning Advisor

SQL Server Profiler

SQL Server Business Intelligence Development Studio

SQL Server Management Studio

Why all that tools removed when I install SQL Server Express Edition .

And thanks with my regarding

Fraas

Hi Fraas,
SQL Server Express does not include the features you listed and so they are not available once you move away from the Trial edition.
Regards,

Mike Wachal

SQL Express team|||thanks for your reply

but how can I install SQL Server 2005 and SQL Server Express Edition on the same machine ?

thanks with my regarding
Fraas|||

In another word how can I install SQL Server 2005 and SQL Server Express Edition in the same machine ?

|||When you install SQL Server Express Edition only select to install the database engine - do not select to install the client components. If you have another edition installed which includes client components you already have everything that's included in the Express client component installation.

Dan
http://blogs.msdn.com/dtjones

I cant Install SQL Server 2005 (final release) in the same machine with SQL Server Express E

Hi

I have download SQL Server 2005 evaluation 180 Days from Microsoft web site and install it fine without any problem in my machine

But when I try to install SQL Server Express edition on the same machine I lose many of start menu tools related to SQL Server 2005 Like.

Analysis Services -> Deployment Wizard

(All) Documentation and Tutorials

Performance Tools -> Database Engine Tuning Advisor

SQL Server Profiler

SQL Server Business Intelligence Development Studio

SQL Server Management Studio

Why all that tools removed when I install SQL Server Express Edition .

And thanks with my regarding

Fraas

Hi Fraas,
SQL Server Express does not include the features you listed and so they are not available once you move away from the Trial edition.
Regards,

Mike Wachal

SQL Express team|||thanks for your reply

but how can I install SQL Server 2005 and SQL Server Express Edition on the same machine ?

thanks with my regarding
Fraas|||

In another word how can I install SQL Server 2005 and SQL Server Express Edition in the same machine ?

|||When you install SQL Server Express Edition only select to install the database engine - do not select to install the client components. If you have another edition installed which includes client components you already have everything that's included in the Express client component installation.

Dan
http://blogs.msdn.com/dtjonessql

I can't change my sql login user's password in SQL Server 2005 Express

SQL Server 2005 Express keeps putting in a different password than the one I chose. I would check the properties on the login I want to change. Then I change the password and it gets accepted. When I try my web application, I get the dreaded "login failed for <loginname>". I look at the properties again and see my password never change. Is this a bug? I ever tried this syntax to no avail:

CREATE LOGIN <loginname> WITH PASSWORD='<mypassword>' CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF

Can you provide some additional information, such as:

- what is the version of the operating system that you are working on?
- how do you check the login password - how do you know it was not set properly? what properties are you checking?

If you get a "Login failed" error, check the SQL Server errorlog as well. It should contain an error state, which can provide additional information on the cause of the error. Please post that error code so that we can determine if the failure is caused by using an incorrect password or some other reason.

Thanks
Laurentiu

|||

In addition to that, the error codes can span a various set of numbers, depending on the error got back. Even in the SQL Server 2005, there are many codes concerning the security features:
Look in here:
http://msdn2.microsoft.com/library/ms131024.aspx

HTH, Jens Suessmeyer.

I can't connect to SQL server 2005 with Management studio express

Hi all,

my server is on internet and can be accessed by sqlb2.webcontrolcenter.com to my hoster.

I subscribe for SQL server 2005

I try to connect to sql server 2005 via Management studio express and visual web developper express without success. i got this error below with both:

Cannot connect to sqlb2.webcontrolcenter.com

a connectionmwas successfully established with the server, but then an error occured during the login process. (Provider: TCP provider, error: 0 -The specified network name is no longer available )

(Microsoft sql server, error 64)

thank's for your help

These errors indicate that the connection between the client and SQL Server was broken for some reason while SQL Server was writing data to the client. You mention that you are accessing the server across the internet, so part of the issue may be routing/firewall rules/devices between you and your provider...if you are able to get through to the server, you may not be able to get data back from the server or vice-versa.

Can you telnet to the TCP port that SQL Server is listening on? i.e. telnet to the IP and port combination you are trying to connect to?

Additionally, ensure your SQL Server is configured to allow remote connections.

This is typcially more of a transport-level issue than SQL Server error (in this case, TCP for example)...

|||

Hello Chad Boyd,

it was my firewall , i put it off and now my connection is working

Thank's for your response

I cant connect to my local sql server express db. Please help

Hello,

I need help to connect to my local sql express db in visual studio 2003 in vb.
It currently works with the production db information and I need to test a few things, So i'd like to point it to the local db.

It works this way:
Const CONN_STRING = "server=johndoe;user id=john;password=doe;database=johnd"
Dim conn As SqlConnection = New SqlConnection(Me.CONN_STRING)
conn.Open()

I want to point it to my local db and it doesn't connect.

Dim connectionString As String = "Data Source={myusername\SQLEXPRESS};Initial Catalog=johnd;Trusted_Connection=yes"
Dim conn As SqlConnection = New SqlConnection(connectionString)

Try
conn.Open()
Catch ex As Exception
Response.Write(ex.ToString())
End Try

and even that doesn't work.

When i go to my sql server 2005, it says
MYUSERNAME\SQLEXPRESS (SQL SERVER 9.0.3042 - theworknetwork\myusername

what am i doing wrong ?

Thanks.

You can try two things:

1) If you are an administrator on your local computer, then make sure that your user ID is in the Administrators group and then make that the Administrators group has access to the SQLEXPRESS instance. Change the user ID used by the SQL Server Management Tool with your local machine login, not your network login. If this doesn't work, replace it with the local machine Administrator account.

2) Instead of using Windows authorizations, use SQL Server authorizations. Create a new user in SQL Server specifically for your database. Make this user the dbo. Then use this user name with password in your ConnectionString.

At times, I have issues with Windows users because the passwords are different across the various computers. This has not been the case with SQL Server credentials, which I usually prefer.

Also, try using Integrated_Security in place of Trusted_Connection in the ConnectionString.

|||

Heres what I've tried. I went to that db (johnd), went to the security>users> and there is already a user called dbo

I tried doing Integrated_Security like you said and i got an error saying that is an invalid key. So here is what I have and it still doesn't work.

"Data Source={myusername\SQLEXPRESS};Initial Catalog=intranet;Trusted_Connection=yes;user id=dbo; password=dbo"

Any ideas?

|||

Can you please try with the following connection string if you are using NT Authentication:

Data Source={localmachine\SQLEXPRESS};Initial Catalog=intranet;Trusted_Connection=yes;

If you are using SQL Server User please try with the following connection string:

Data Source={localmachine\SQLEXPRESS};Initial Catalog=intranet;user id=<local sql server user>; password=<password>

Please make sure that you are changing the bold string with appropriate values.

Following URL provides you the steps to create the user:

http://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse.mspx

|||

I am in microsoft sql server managemen studio Object explorer (on left)
The very first item shows SDAVID\SQLEXPRESS

underneath that i have my database intranet

I then went to security > users [right click] > New User
Under Database User - New,
User Name: SDAVID
Login name
a new window came for Select Login and i found SDAVID [hit okay.]
* so now it shows User name: SDAVID
and login name shows SDAVID

under schemas owned by this user, I choose db_owner and db_securityadmin
under database membership i choose db_owner and db_securityadmin

Now under the code, here is what i have...

Const dbstring = "Data Source={SDAVID\SQLEXPRESS};Initial Catalog=intranet;user id=<sdavid>; password=<sdavid>"

Public Function testConnection()
Dim connectionString As String = "Data Source={SDAVID\SQLEXPRESS};Initial Catalog=intranet;user id=<sdavid>; password=<sdavid>"
Dim conn As SqlConnection = New SqlConnection(ConnectionString)
Dim cmd As SqlCommand = New SqlCommand("selec * from tblUsers", conn)
cmd.CommandType = CommandType.Text
Try
conn.Open()
Catch ex As Exception
Response.Write(ex.ToString())
Finally
conn.Close()
End Try

this generates the following error:
sqlException: Sql server does not exists or access denied.

thanks.

|||

Can you please use the following modified connection string:

Const dbstring = "Data Source=SDAVID\SQLEXPRESS;Initial Catalog=intranet;user id=sdavid; password=sdavid"

|||

Thank you. that did it! ..
Data Source=SDAVID\SQLEXPRESS;Initial Catalog=intranet;Trusted_Connection=yes;

|||

Hey Sri,

I tried it your way with specifying username and password and that did not work. Do you know why this could be ?

in Micrososft Sql Server Mangement Studio, i went to the db, Security > USers and created a user called sdavid with sdavid. I gave the user db_datareader and db_owner an under database roles membership gave it db_owner... i'd like to get the app working sql sever authhentication.

thanks.

I can't change my sql login user's password in SQL Server 2005 Express

SQL Server 2005 Express keeps putting in a different password than the one I chose. I would check the properties on the login I want to change. Then I change the password and it gets accepted. When I try my web application, I get the dreaded "login failed for <loginname>". I look at the properties again and see my password never change. Is this a bug? I ever tried this syntax to no avail:

CREATE LOGIN <loginname> WITH PASSWORD='<mypassword>' CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF

Can you provide some additional information, such as:

- what is the version of the operating system that you are working on?
- how do you check the login password - how do you know it was not set properly? what properties are you checking?

If you get a "Login failed" error, check the SQL Server errorlog as well. It should contain an error state, which can provide additional information on the cause of the error. Please post that error code so that we can determine if the failure is caused by using an incorrect password or some other reason.

Thanks
Laurentiu

|||

In addition to that, the error codes can span a various set of numbers, depending on the error got back. Even in the SQL Server 2005, there are many codes concerning the security features:
Look in here:
http://msdn2.microsoft.com/library/ms131024.aspx

HTH, Jens Suessmeyer.

I cannot view table content in MS SQL Server Express

I was able to view table content easily before, but after I
reinstalled everything, I cannot find the option to view table content
in MS SQL Server Express. I can define table with no problem. Check
out the screen snapshot below, from which you'll see that the popup
menu frrom right-clicking on the table name does not have the "Open
table" option. What is going on?

http://farm1.static.flickr.com/167/...839620d0b_o.pngIt seems you are not connected to an SQL Server Express Edition
server. Instead, you are connected to a SQL Server Compact Edition
server, which is a different thing.

Razvan|||On Mar 19, 1:55 am, "Razvan Socol" <rso...@.gmail.comwrote:

Quote:

Originally Posted by

It seems you are not connected to an SQL Server Express Edition
server. Instead, you are connected to a SQL Server Compact Edition
server, which is a different thing.
>
Razvan

Yes, yes, you are very right. I also notice that. But how come? I
did download the package from the SQL Server Express website. It is
the one which says "Microsoft SQL Server 2005 Express Edition with
Advanced Services". The installation file has a name SQLEXPR_ADV.EXE,
which is 256M.

Is this the right one? Well, at installation, I did custom install
and made all components available from the local machine.

Pls give me hint, how do I properly install the Express Edition
instead of the compact Edition?

Thanks.|||I guess that both SQL Express and SQL Compact are installed now. It's
only a matter of connecting to the desired one. When the "Connect to
Server" dialog appears in Management Studio Express, make sure you
choose "Database Engine" in the "Server type" combo (instead of "SQL
Server Compact Edition").

Razvan|||On Mar 19, 12:07 pm, "Razvan Socol" <rso...@.gmail.comwrote:

Quote:

Originally Posted by

I guess that both SQL Express and SQL Compact are installed now. It's
only a matter of connecting to the desired one. When the "Connect to
Server" dialog appears in Management Studio Express, make sure you
choose "Database Engine" in the "Server type" combo (instead of "SQL
Server Compact Edition").
>
Razvan

You are right again. Yes, both "Database Engine" and "Sql Server
Compact Edition" show up in the combo. The problem is that I cannot
connect to .\SQLEXPRESS with Database Engine selected, using Windows
Authentication.|||[...] I cannot connect to .\SQLEXPRESS with Database Engine selected,

Quote:

Originally Posted by

using Windows Authentication.

What error message do you get (below "Cannot connect to .
\SQLEXPRESS") ?
a) "An error has occurred while establishing a connection to the
server [...] Error Locating Server/Instance Specified"
b) "Login failed for user 'COMPUTERNAME\username'"

I guess that a). In this case, go to Start / Programs / SQL Server
2005 / Configuration Tools / SQL Server Configuration Manager. Under
"SQL Server 2005 Services" do you have any entry with the "SQL Server"
as the "Service Type" ?

If yes, try to connect to the instance name specified there (if it's
the default instance, just try to connect to ".").

If no, then the Database Engine seems to be not installed; when you
reinstall SQL Server, make sure that "Data files" and "Shared tools"
under "Database Services" are selected. Then remember what choice you
make in the Instance Name screen.

Razvan|||On Mar 19, 3:44 pm, "Razvan Socol" <rso...@.gmail.comwrote:

Quote:

Originally Posted by

Quote:

Originally Posted by

[...] I cannot connect to .\SQLEXPRESS with Database Engine selected,
using Windows Authentication.

>
What error message do you get (below "Cannot connect to .
\SQLEXPRESS") ?
a) "An error has occurred while establishing a connection to the
server [...] Error Locating Server/Instance Specified"
b) "Login failed for user 'COMPUTERNAME\username'"
>
I guess that a). In this case, go to Start / Programs / SQL Server
2005 / Configuration Tools / SQL Server Configuration Manager. Under
"SQL Server 2005 Services" do you have any entry with the "SQL Server"
as the "Service Type" ?
>
If yes, try to connect to the instance name specified there (if it's
the default instance, just try to connect to ".").
>
If no, then the Database Engine seems to be not installed; when you
reinstall SQL Server, make sure that "Data files" and "Shared tools"
under "Database Services" are selected. Then remember what choice you
make in the Instance Name screen.
>
Razvan

Hey, Razvan, you really rock!

Exactly that was the problem. I checked the configuration manager.
It looks like that I don't have SQLEXPRESS. The instance name seems
to be MSSQLSERVER.

My computer name is EMACHINEXPPRO and I can connect to the SQL Server
by typing in this computer name as the Database Engine or like you
said, simply put a dot (.) instead.

Connecting to MSSQLSERVER or .\MSSQLSERVER results in error (error
code 53 or error code 87). See the screen snapshot below.

http://farm1.static.flickr.com/175/...8f5145e32_o.png
Good that I can connect to it using my computer name now. Many
thanks.

AL

i cannot run express after i have installed it

my system meets the requirements and I have installed .net framework 2.0,

why can't i run sql express?

I tried running it from command prompt but nothing happens?

hi,

how did you "run" the SQLEXPR.EXE boostrap installer? please have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx for command prompt required and supported parameters...

as regards "system requirements", be sure they are satisfied as exposed in http://msdn2.microsoft.com/en-us/library/ms143680.aspx

and just to be sure () you can have a look at http://msdn2.microsoft.com/en-us/library/ms143441.aspx as well ...

regards

I cannot logon to Http://localhost/reports$sqlexpress

Hello,
I am completely stuck. I have installed SQL server express server
advanced with reporting services. I can create some reports in Visual
studio 2005 IDE (from Acces database) but I cannot login to subj
address to do something from the web
I get the following response from my browser:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance
What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
functioning. I am logged as a user with Administrator rights. I can
browse web pages hosted on my IIS.
Searc on Google on this reveals a lot of hits which I have gone
through but no avail.
Also, how can I check that I have ASP.NET enabled on IIS'
Thanks,
AivarsOn Mar 15, 5:52 pm, "Aivars" <aiva...@.apollo.lv> wrote:
> Hello,
> I am completely stuck. I have installed SQL server express server
> advanced with reporting services. I can create some reports in Visual
> studio 2005 IDE (from Acces database) but I cannot login to subj
> address to do something from the web
> I get the following response from my browser:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance
> What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
> functioning. I am logged as a user with Administrator rights. I can
> browse web pages hosted on my IIS.
> Searc on Google on this reveals a lot of hits which I have gone
> through but no avail.
> Also, how can I check that I have ASP.NET enabled on IIS'
> Thanks,
> Aivars
You may need to reinstall SSRS Express w/Advanced Services. I had a
similar issue a few months back and that seemed to resolve it. To
check if ASP.NET is enabled for IIS, do the following:
- Right click 'My Computer' and select 'Manage.'
- Select Services and Applications -> Internet Information Services ->
Default Web Site
- Right-click either the Reports or ReportServer virtual directory and
select Properties.
- There should be a tab at the end called 'ASP.NET'. If you select it,
it will show you the ASP.NET version, etc.
- Also, the Virtual Directory tab is where you would set up connection
pooling (in case you needed to run different versions of Visual
Studio/ASP.NET and need to control which .NET framework is used for
what).
Hope this helps.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||Running the following statement in your Framework\v2.0.50727 directory
might help:
aspnet_regiis -i -enable
Regards,
Thomas
Aivars schrieb:
> Hello,
> I am completely stuck. I have installed SQL server express server
> <SNIP>
> Also, how can I check that I have ASP.NET enabled on IIS'|||Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
times all SSRS and Toolkit and still I am getting the following error
when logging to reportserver:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance.
No clue whatsoever.
Any more ideas?
Aivars
Thomas H=FCtter wrote:
> Running the following statement in your Framework\v2.0.50727 directory
> might help:
> aspnet_regiis -i -enable
> Regards,
> Thomas
>
> Aivars schrieb:
> > Hello,
> > I am completely stuck. I have installed SQL server express server
> > <SNIP>
> > Also, how can I check that I have ASP.NET enabled on IIS'|||Well, what do your event logs say around the time the error happens?
Aivars schrieb:
> Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> times all SSRS and Toolkit and still I am getting the following error
> when logging to reportserver:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance.|||Thomas, thank you very much.
I reinstalled windows(!). Now i can at least get the to the home page
of reportserver (it looks like it) but it responds with an error:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer. But it is a home page
of report server.
It looks like I am closer. What is that last thing which I am
suppposed to do?
I think that is something to do with windows xp security?
Thanks,
Aivars
Thomas H=FCtter wrote:
> Well, what do your event logs say around the time the error happens?
>
> Aivars schrieb:
> > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > times all SSRS and Toolkit and still I am getting the following error
> > when logging to reportserver:
> >
> > The server has encountered an error while loading an application
> > during the processing of your request. Please refer to the event log
> > for more detail information. Please contact the server administrator
> > for assistance.|||Finally I did get it to work. I had tu use rskeymgmt utility to delete
encrypted contend. And do not ask me why because i do not know myself
how i had something encrypted on server.
maybe when configuring the report server there is an option to encrypt
and i had used it by accident.
Anyway, thanks to all who responded. There is a plethora of
information in Books online and Google is your friend!
Aivars
Aivars wrote:
> Thomas, thank you very much.
> I reinstalled windows(!). Now i can at least get the to the home page
> of reportserver (it looks like it) but it responds with an error:
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer. But it is a home page
> of report server.
> It looks like I am closer. What is that last thing which I am
> suppposed to do?
> I think that is something to do with windows xp security?
> Thanks,
> Aivars
> Thomas H=FCtter wrote:
> > Well, what do your event logs say around the time the error happens?
> >
> >
> > Aivars schrieb:
> > > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > > times all SSRS and Toolkit and still I am getting the following error
> > > when logging to reportserver:
> > >
> > > The server has encountered an error while loading an application
> > > during the processing of your request. Please refer to the event log
> > > for more detail information. Please contact the server administrator
> > > for assistance.

I can′t install SQL Server 2005 Express

Hi, there!

I tried to install SSE 2005 and I got the following message:

SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file in...

The log file has the content below. Can someone help me to fix this problem, please?

I have no idea about what is going on!

Thank you for the help!

Microsoft SQL Server 2005 Setup beginning at Sun Jul 23 12:52:54 2006
Process ID : 2420
c:\97830b63babac24aedb48a81be43976a\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/6/23 12:52:53
Complete: LoadResourcesAction at: 2006/6/23 12:52:53, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/23 12:52:53
Loaded DLL:c:\97830b63babac24aedb48a81be43976a\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/6/23 12:52:54, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/6/23 12:52:54
Complete: ValidateWinNTAction at: 2006/6/23 12:52:54, returned true
Running: ValidateMinOSAction at: 2006/6/23 12:52:54
Complete: ValidateMinOSAction at: 2006/6/23 12:52:54, returned true
Running: PerformSCCAction at: 2006/6/23 12:52:54
Complete: PerformSCCAction at: 2006/6/23 12:52:54, returned true
Running: ActivateLoggingAction at: 2006/6/23 12:52:54
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00E2CFC4Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Redirecting to the setup forum.

Mike

I can´t install SQL Server 2005 Express

Hi, there!

I tried to install SSE 2005 and I got the following message:

SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file in...

The log file has the content below. Can someone help me to fix this problem, please?

I have no idea about what is going on!

Thank you for the help!

Microsoft SQL Server 2005 Setup beginning at Sun Jul 23 12:52:54 2006
Process ID : 2420
c:\97830b63babac24aedb48a81be43976a\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/6/23 12:52:53
Complete: LoadResourcesAction at: 2006/6/23 12:52:53, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/23 12:52:53
Loaded DLL:c:\97830b63babac24aedb48a81be43976a\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/6/23 12:52:54, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/6/23 12:52:54
Complete: ValidateWinNTAction at: 2006/6/23 12:52:54, returned true
Running: ValidateMinOSAction at: 2006/6/23 12:52:54
Complete: ValidateMinOSAction at: 2006/6/23 12:52:54, returned true
Running: PerformSCCAction at: 2006/6/23 12:52:54
Complete: PerformSCCAction at: 2006/6/23 12:52:54, returned true
Running: ActivateLoggingAction at: 2006/6/23 12:52:54
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00E2CFC4Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Redirecting to the setup forum.

Mike

I can't find the setting.

Hi, I'm completely new to SQL Server and ASP.NET, so please bear with me on my learning curve! I've installed Visual Web Developer Express and SQL Server Express (on the same PC). I then used Web Developer Express to successfully create a new database with a couple of tables in it. So far so good. I then installed SQL Server Management Studio Express on the same PC and tried to connect to my new database. The connection to the SQL Server instance appears to work OK (using Windows Authentication) but I can't see the database I previously created. All I can see are the System Databases. Does anyone know what the solution might be?

Ensure you are really connected to the same SQL Server instance, you could have multiple instances. Ensure you are connecting using the same credentials, your Windows Authenication account may have different permissions than the account used to by Web Developer Express.

Let me know if this does not help

Peter Saddow

|||

Thank you for the feedback. I eventually found out what the problem was: by default, Web Developer Express creates SQL databases which are visible only to the current User Instance. To disable this, you have to set "User Instance = FALSE" on the database connection string. For example, my original connection string was:

Data Source=.\SQLEXPRESS;AttachDbFilename="S:\My Documents\Visual Studio 2005\WebSites\Db1\App_Data\Database.mdf";Integrated Security=True;User Instance=True

By setting User Instance = False, I can now see the database from SQL Server MSE.

|||I came across the same answer you did the only problem is that I may not find the settings file or some way to edit it.

I can't connect to my local database.mdf file

I have just upgraded to Microsoft SQL Server 2005 Express Edition with Advanced Services SP2.

Now I can't connect to my local database.mdf file.

When trying to open or doubleclick or expand my .mdf file the following message pops up:

Generating user instances in SQL Server is disabled. Use sp_configure 'user instance enabled' to generate user instances.

What is the solution for this problem?

hi,

by default, User Instances feature is disabled when you install a SQLExpress instance.. the Install Wizard provides an option to enable it at install time, but you can enable it via sp_configure execution as

EXEC sp_configure 'show advanced option', '1'; GO EXEC sp_configure 'user instances enabled','1'; GO RECONFIGURE GO EXEC sp_configure 'show advanced option', '0'; GO

(restart the SQLExpress service)

that can be executed both in SqlCmd.exe (command line tool) or in a SQL Server Management Studio Express query window (or even via an ADO/Ado.Net connection)..

you can have a look at all "configurable" options at http://msdn2.microsoft.com/en-us/library/ms189631.aspx

regards

|||

Hi Andrea.

I have entered your code in the query editor and saved it as SQLQuery5.sql.
SQL server is restarted.

I right clicked in the query editor and hit Execute and get the folloving error:

Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

The problem is still there?...

|||

Hi again :)

I right clicked in the query editor and hit Execute again after a while. It works now.

Thanks :)

I can't connect to my local database.mdf file

I have just upgraded to Microsoft SQL Server 2005 Express Edition with Advanced Services SP2.

Now I can't connect to my local database.mdf file.

When trying to open or doubleclick or expand my .mdf file the following message pops up:

Generating user instances in SQL Server is disabled. Use sp_configure 'user instance enabled' to generate user instances.

What is the solution for this problem?

hi,

by default, User Instances feature is disabled when you install a SQLExpress instance.. the Install Wizard provides an option to enable it at install time, but you can enable it via sp_configure execution as

EXEC sp_configure 'show advanced option', '1'; GO EXEC sp_configure 'user instances enabled','1'; GO RECONFIGURE GO EXEC sp_configure 'show advanced option', '0'; GO

(restart the SQLExpress service)

that can be executed both in SqlCmd.exe (command line tool) or in a SQL Server Management Studio Express query window (or even via an ADO/Ado.Net connection)..

you can have a look at all "configurable" options at http://msdn2.microsoft.com/en-us/library/ms189631.aspx

regards

|||

Hi Andrea.

I have entered your code in the query editor and saved it as SQLQuery5.sql.
SQL server is restarted.

I right clicked in the query editor and hit Execute and get the folloving error:

Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

The problem is still there?...

|||

Hi again :)

I right clicked in the query editor and hit Execute again after a while. It works now.

Thanks :)

i can not install MSQL server 20005 TCP Express April Edition

hello all
during the instaletion i get an error message that SQL server can not start the service, after that the programm rolls instalation back.
do someone knows what's going on?
i use win xp pro.
thank u for ur help.Try the link below to download the June CTP, it could make a difference. Hope this helps.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx#EBAA|||thanks Caddre but it does not change the situation.
but i have found one blog that describe that, if someone have the same problem this topic can help:
http://blogs.msdn.com/sqlexpress/archive/2005/05/24/421563.aspx
regards

I can not enter non english text in SQL express...

I am trying to add non English text in a table in my sql express but when it refreshes the entry returns unrecorgizable characters(@.#$@.)

Haw may I configure sqlexpress languages or is there something else I should know?

Many thanks in advance

Are your column types nchar/nvarchar/ntext or are they just char/varchar/text?

In order to use international strings, you must store the data with wide character types.

|||

Hello,

I had no idea about it... I will change the field type

Thanks

I can no longer connect to my SQL Server Express 2005 from Manager Studio Express

Everything was working fine. I have been able to connect using windows authentication. Then, I went into the ODBC manager to add a data source and it failed to connect so I went back into the Server management studio to modify users. After doing this I now get an error when I try to conenct the management studio to the SQL server.

I wasn't modifying the login for my windows account that I normally use, I was modifying a different one, however I now get the message "An error has occured while establishing a connection to the SQL server. This kind of problem can ocure because the default behavior of the server does not support all connection methods" blah blah.

Does anyone know how I can attach to the server? Or, do I need to somehow remove the server and create a new one? How would I do that?

Thanks in advance for any input.

Hi,

did you disable remote connections by accident ? If so, see if this feature is enabled under the Serface Configuration. See more detaisl on the screencast on my site.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

I asked this in Sql Express but hoping to get a different answer here.

Here is my goal please let me know if it is possible.

I have installed sql express on clients machines. I don't want them to be able to view the sp's or the functions. I would like to go as far as not allowing them to see the tables. I tried with encrption but this is still breakable by the user using the DAC.

Does CE

Support transactionscope?

What would I use to create tables and sp's for my sdf database? Server Managment Studio or something else?

Thanks

Stored procedures are not available in SQL CE.

The next version of CE (3.5) will support transactionscope on the desktop (not of Windows Mobile)

Create tables from SSMS, yes, or use the CREATE TABLE / CREATE INDEX statements (in SSMS Query window)

You may find this useful: http://blogs.msdn.com/stevelasker/archive/2007/03/31/creating-your-sql-server-compact-edition-database-and-schema-in-code.aspx

|||

Is there any whitepapers on performance of Sql CE compared to Sql Express?

Is there a way to use profiler to see whats going on in SQL CE?

can I see the database in SMS if it has a passowrd on it and has been encrypted?

Is there a conversion tool to convert from Express or 2005 to CE db?

Thanks

|||

You have a lot of questions!! :-)

1: Yes, there is some info here: http://msdn2.microsoft.com/en-us/library/bb380177.aspx

2: You can use Management Studio - Query analyzer with SQL CE, to see which indexes are used etc. Profiler is not available

3: Yes, you will be prompted for the password (having a password == being encrypted)

4: Yes, there are 3rd party tools, and a data migration wizard is in the works in the Visual Studio "Orcas" timeframe.

|||

Is there any reason that varchar is not supported?

Is there a plan to support this in the next version?

Thank you for your help this is really looking like it will work well for me.

|||

Do you have any links for the 3rd party tools for the data migration?

I think I know the answer is No but I will still ask.

Are scalar functions available in CE?

|||

I will try to answer more questions for you:

> Is there any reason that varchar is not supported?

I am not sure in understand this. nvarchar() is supported (as SQL CE uses only unicode, varchar is not), but you can always convert from varchar til nvarchar. I doubt there are any plans to support varchar in a future version.

> Do you have any links for the 3rd party tools for the data migration?

DataPort wizard from www.primeworks-mobile.com

> Are scalar functions available in CE?

Yes, some functions are, for a full list see http://msdn2.microsoft.com/en-us/library/ms174077.aspx

|||

Thank you for the answers that product worked great. One thing I noticted and wondering if I am missing something. Is there no way to create a clustered index in ce?

|||One more question is there a way to scrip the whole db.|||

Is there any Microsoft Application blocks for CE?

|||

if i want to run 2 selects in the same call to the db is this possible or would I have to do 2 calls to and get 2 different SQLCeResultSets back.

|||

I will again try to answer some of your questions - I you find my answers useful, please be kind and mark them as being so, thanks.

> One thing I noticted and wondering if I am missing something. Is there no way to create a clustered index in ce?

No, only Non-clustered indexes are supported - see http://msdn2.microsoft.com/en-us/library/ms345331.aspx

> One more question is there a way to scrip the whole db.

Do you mean scripting an existing SDF file. If so, not without 3rd party tools (see reply above). You may find this useful:

http://blogs.msdn.com/stevelasker/archive/2007/03/31/creating-your-sql-server-compact-edition-database-and-schema-in-code.aspx

> Is there any Microsoft Application blocks for CE?

Sure is - the "Mobile Client Software Factory" contains a SQL CE Data Access block: http://www.microsoft.com/downloads/details.aspx?familyid=F9176708-9F57-4C0F-97FB-F9C65A9BBF22&displaylang=en

> if i want to run 2 selects in the same call to the db is this possible or would I have to do 2 calls to and get 2 different SQLCeResultSets back.

You must make two calls, only on SQL stament is supported per command.

Hope you found my reply useful.

|||

Select count(distinct(column)) from table

Any way to get this to work or will I have to just select out distinct values and manully count them in C# when I return it out.

|||

How can I do a select like this in CE?

SELECT
col1
FROM
table1 as A
JOIN
(SELECT
col1
FROM
table2
) B
ON
A.col1 = B.col1

Thanks

|||Nested FROM queries are not supported by SQL CE. You will have to rephrase or use 2 calls. Nested queries will be available in the next version of SQL CE (3.5)