Error when trying to create "datasources"

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

I also ran into this problem and got it solved by removing the connection strings in 'My Project - Settings'. I hope this also works for you.

Harmen.|||

Thanks for that idea

For the record had trouble removing strings however -

My problems have been solved by accident when I created a new windows user account and ran VB express from there. I believe the problem was to do with the connection address because my system name has an " & " in the name(stupid me when I set up Windows XP ) the ampersand maybe an illegal character in a path name.

Here's the full path i used

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\TB&MA\My Documents\Visual Studio 2005\Projects\MyDataBase\MyDataBase\Database1.mdf";Integrated Security=True;User Instance=True

I think this why running it from a new user account worked ok as the connection string would have new directory path name

Thanks again

sql

Error when trying to create "datasources"

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

I also ran into this problem and got it solved by removing the connection strings in 'My Project - Settings'. I hope this also works for you.

Harmen.
|||

Thanks for that idea

For the record had trouble removing strings however -

My problems have been solved by accident when I created a new windows user account and ran VB express from there. I believe the problem was to do with the connection address because my system name has an " & " in the name(stupid me when I set up Windows XP ) the ampersand maybe an illegal character in a path name.

Here's the full path i used

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\TB&MA\My Documents\Visual Studio 2005\Projects\MyDataBase\MyDataBase\Database1.mdf";Integrated Security=True;User Instance=True

I think this why running it from a new user account worked ok as the connection string would have new directory path name

Thanks again

Error when trying to access http://localhost/Reports

Hello,

I just recently installed SQL Express 2005 Reporting Services on a new OS "Vista Ultimate". I used for reference the video # 10 Getting Started with Reporting Services found in

SQL Server Videos - SQL Server 2005 Express for Beginners. I was finally able to install everthing, including creating a new project using Report Server Project Wizard.

The only problem I recieve when fallowing the video is opening IE and enteringhttp://localhost/Reports. What I recieve is an error"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

I checked to see if the SQL Server Reporting Services was running which it was. I also checked the Default Web Site in IIS manger which was also running.

Any help would be much appreciated

Regards

Karl

May be the problem is just configuration check this link it might help you

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

Error When Opening SSMS Express

Hi, everyone.

I'm getting the following error when opening SQL Server Management Studio Express (long error message -- sorry).

************** Exception Text **************
System.IO.IOException: Cannot create a stable subkey under a volatile parent key.

at Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str)
at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey, RegistryKeyPermissionCheck permissionCheck, RegistrySecurity registrySecurity)
at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.CreateKeyValueIfNotExist(String regPath, String keyName)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.RegisterLocalInstancesIfFirstTimeUser()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I'm running on a clean install of Windows XP SP2, using SQL Server Express 2005 SP1, and Visual Studio 2005 Standard. I can click Continue and everything seems to work ok. However the same error message pops up intermittently when I'm working. I have tried the usual uninstall SSMSE and reinstall. I get the same results. I didn't have this error when using SSMSE CTP.

Any help would be appreciated. Thanks.

Flynn

Oddly enough, when I opened SSMSE this morning, it ran the initial setup and now everything works fine. I can only think it's because I logged off and back on after installing instead of performing a complete reboot cycle.

Anyway, I'm not getting any errors now when opening the program, or when working in it.

Flynn

sql

Error when Logging on - Error: 18456, Severity: 14, State: 16

Hi All,
I am getting the following error in the ERRORLOG File when I am
trying
to connect to SQL Server 2005 Express Edition from the command line.
2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State:
16.
2007-03-23 07:30:05.54 Logon Login failed for user 'sa'.
[CLIENT: xx.xx.xx.xx]
I have a fresh install of SQL Server on my local machine, which is
probably the source of my angst, but I am trying to create a database
from scratch through using a batch file that is run from the command
line, the batch file looks like this:
<snip>
SQLCMD -U %USR% -P %PWD% -S %SVR% -d %DBF% -i CreateDatabase.sql
<snip>
The values of %USR% and %PWD% are correct as I frequently log into
Management Studio with the details, %SVR% is "<ComputerName>
\SQLEXPRESS,1433" and %DBF% is <DatabaseName>. The contents of
CreateDatabase.sql when run in Management Studio successfully creates
the database that I require so I know the error doesn't lie there.
The command line error that is showing reads as the following:
Msg 4060, Level 11, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
Cannot open database "<DatabaseName>" requested by the login. The
login failed.
Msg 18456, Level 14, State 1, Server <ComputerName>\SQLEXPRESS, Line
1
Login failed for user 'sa'.
I have a feeling that it is related to 'sa' not having the correct
permissions with regards to logging into or creating a database from
scratch, but I find it odd that I can login as 'sa' in Management
Studio and create the database from there, but when I try it from the
command-line (despite having TCP/IP enabled) it won't let me connect
to create a database.
Is there something I am missing here? I have been banging my head off
of walls for days over this and am unsure of the next steps to take.
If any of this screams "why the hell are you doing this?" then please
let me know as at the moment I am punching in the dark with this
problem, I have searched Usenet, Google Groups, the Web and although
I
have found potential solutions to this particular problem I am
having,
nothing I have done so far has actually managed to fix the issue.
Related articles I have followed are:
Login failed for user 'x'
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
Change Server Authentication Mode
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
Upgrading MSDE 2000 to SQL Server 2005 Express [Enabling network
protocols section]
http://www.microsoft.com/technet/pr...e2sqlexpress...
NOTE: I just listed these articles to show what path I am currently
looking at with regards to this problem, but again I stress I have
found nothing yet to get round this problem, and any further articles
or direction would be much appreciated.
Yours Distressingly
AlastairI'm still not clear on what database is used for -d
<DatabaseName> and this could be one of the problems. If you
are trying to log in using the database you are about to
create, then that's likely the issue as it doesn't exist
when logging in. Try specifying master for the initial login
database.
-Sue
On 23 Mar 2007 08:48:10 -0700, "Alastair"
<alastair_anderson@.hotmail.com> wrote:

>Hi All,
>I am getting the following error in the ERRORLOG File when I am
>trying
>to connect to SQL Server 2005 Express Edition from the command line.
>
>2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State:
>16.
>2007-03-23 07:30:05.54 Logon Login failed for user 'sa'.
>[CLIENT: xx.xx.xx.xx]
>
>I have a fresh install of SQL Server on my local machine, which is
>probably the source of my angst, but I am trying to create a database
>from scratch through using a batch file that is run from the command
>line, the batch file looks like this:
>
><snip>
>SQLCMD -U %USR% -P %PWD% -S %SVR% -d %DBF% -i CreateDatabase.sql
><snip>
>
>The values of %USR% and %PWD% are correct as I frequently log into
>Management Studio with the details, %SVR% is "<ComputerName>
>\SQLEXPRESS,1433" and %DBF% is <DatabaseName>. The contents of
>CreateDatabase.sql when run in Management Studio successfully creates
>the database that I require so I know the error doesn't lie there.
>
>The command line error that is showing reads as the following:
>
>Msg 4060, Level 11, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
>Cannot open database "<DatabaseName>" requested by the login. The
>login failed.
>Msg 18456, Level 14, State 1, Server <ComputerName>\SQLEXPRESS, Line
>1
>Login failed for user 'sa'.
>
>I have a feeling that it is related to 'sa' not having the correct
>permissions with regards to logging into or creating a database from
>scratch, but I find it odd that I can login as 'sa' in Management
>Studio and create the database from there, but when I try it from the
>command-line (despite having TCP/IP enabled) it won't let me connect
>to create a database.
>
>Is there something I am missing here? I have been banging my head off
>of walls for days over this and am unsure of the next steps to take.
>
>If any of this screams "why the hell are you doing this?" then please
>let me know as at the moment I am punching in the dark with this
>problem, I have searched Usenet, Google Groups, the Web and although
>I
>have found potential solutions to this particular problem I am
>having,
>nothing I have done so far has actually managed to fix the issue.
>
>Related articles I have followed are:
>
>Login failed for user 'x'
>http://msdn2.microsoft.com/en-us/library/ms366351.aspx
>
>Change Server Authentication Mode
>http://msdn2.microsoft.com/en-us/library/ms188670.aspx
>
>Upgrading MSDE 2000 to SQL Server 2005 Express [Enabling network
>protocols section]
>http://www.microsoft.com/technet/pr...e2sqlexpress...
>
>NOTE: I just listed these articles to show what path I am currently
>looking at with regards to this problem, but again I stress I have
>found nothing yet to get round this problem, and any further articles
>or direction would be much appreciated.
>
>Yours Distressingly
>
>Alastair|||On 25 Mar, 16:17, Sue Hoegemeier <S...@.nomail.please> wrote:
> I'm still not clear on what database is used for -d
> <DatabaseName> and this could be one of the problems. If you
> are trying to log in using the database you are about to
> create, then that's likely the issue as it doesn't exist
> when logging in. Try specifying master for the initial login
> database.
> -Sue
> On 23 Mar 2007 08:48:10 -0700, "Alastair"
>
> <alastair_ander...@.hotmail.com> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
You managed to hit the nail on the head.
Running my current script when the new database already exists it
works fine, however for a fresh install of SQL Server, when it doesn't
currently exist then it doesn't work.
Thanks for your help
Alastair

Error when installing SQL Server Express

Hi All,

I have a problem when installing SQL Server Express Advanced Edition

It crash when installing Database Services, the log file contains this message

.....

<Func Name='GetSkuIt'>
GetServiceUserGroup failed for SQLEXPRESS, 5
Error Code: 0x80070534 (1332)
Windows Error Text: Le mappage entre les noms de compte et les ID de scurit n'a pas t effectu.
Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Fri Feb 9 22:35:05 2007
Function Name: SetInstanceProperty
Source Line Number: 1223

Error Code: 1332
MSI (s) (E0!E8) [10:34:39:288]: Produit : Microsoft SQL Server 2005 -- Erreur 29528. Le programme d'installation a rencontr une erreur inattendue pendant Dfinition des proprits internes. L'erreur est : Erreur irrcuprable lors de l'installation.

Erreur 29528. Le programme d'installation a rencontr une erreur inattendue pendant Dfinition des proprits internes. L'erreur est : Erreur irrcuprable lors de l'installation.

<EndFunc Name='LaunchFunction' Return='1332' GetLastError='203'>
Fin de l'action 10:34:39 : SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Valeur renvoye : 3.
Fin de l'action 10:34:39 : INSTALL. Valeur renvoye : 3.
.......

Can someone help me ?

Thx

Hi,

this might helps http://support.microsoft.com/default.aspx/kb/925976.

|||

No, it won't.

Maybe my windows was in a bad state.

I've see that there is no group in local group ..... and a lot of bad news.

I format .........

Thx for your help.

Error when connecting to SQL Server

Hi

when i tried connecting to SQL Server Express I got this error, be it connecting via Windows Authentication or SQL Authentication. Pls see below for the error message:

===================================

Cannot connect to JOHNSON\SQLEXPRESS.

===================================

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

Error Number: -1
Severity: 20
State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

wats wrong with my setup? Previously it can connect. till i upgraded to SQL Server 2005 then uninstall my SQL Server 2005 then it become like tt....

what shld i do?

Pls advise.

Thanks

Johnson

Did you enable remote connections ? This is disabled by default. See the Screencast on my site for more information.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi,

THanks for the reply but when i look into ur screencast and followed the steps to enable remote connection, I got the below error when try to click on the Surface Area Configureation.

"===================================

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)

Program Location:

at Microsoft.SqlSac.MainPanel.FormServicesAndProtocols.ProcessClassConstructor()"

By the way y do i nd to enable remote connection when i am trying to connect to only my local SQLExpress?

I am using SQL Express and not SQL Server 2005.

Thanks

Johnson

|||Are you trying to configure the local computer ?|||

ya i m trying to access my SQL Mobile database using my SQL Server Management Studio Express. But when i tried connecting using SQL Server Management Studio Express to my local machine, I got thrown the error.

As mentioned I previously upgraded my SQL Server Express to SQL Server 2005. Thereafter I uninstall my SQL Server 2005 and reinstall ym VS 2005. So i duno is it cos of this. If so, wat shld I do to resolve this?

Can u advise wat's wrong?

Thanks

Johnson

|||

Hi Johnson,

I'm trying to understand what you're really trying to do here because your information is conflicting, maybe you can clarify a bit...

Are you trying to work with SQL Mobile or SQL Express? They are two different products. Do you have SQL Express installed or not? You've claimed that you installed it, then uninstalled it. You can't connect to it if you've uninstalled it. Do you have an entry on your Start menu for Microsoft SQL Server 2005? What is on it?|||

SQL Network Interfaces, error: 26 - Error Locating Server/Instance SpecifiedSQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

This usually means the application cannot contact your SQL Browser. So, make sure SQL Browser is running and it's firewalled(put sqlbrowser.exe or UDP 1434 into exception).

|||

Hi Thanks..

I resolve the problem already. cos there isnt any SQL Server instance installed

Thanks

Johnson

Error when connecting to SQL Express

Hi - can anyone please help?

I am using SQL Express 2005 - and have an asp (yes legacy asp) site running locally. It works ok, until I try and connect to the server from another PC.

The error message I get is:

******

Microsoft OLE DB Provider for SQL Servererror '80004005'

Cannot open database "fixit" requested by the login. The login failed.

/fixitnew/fixit_login.asp, line 30

******

Line 30, is where I open the connection to the database.

My connection string is:

myConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=fixit;Data Source=misinvaknb01\sqlexpress;"

Can anyone please help?

Thanks in advance,

Mark

Hi

Default user has no permission to access fixit database . Follow those steps:

In Management Studio choose Security->Logins ->WindowsUserName->right click choose property->UserMapping -->Checkfixit database

Hope it helps.

error when changing published article at the subscriber

Hi

Using merge replication - the stored procs are published articles.

When trying to change the article at the subscriber (sql express) I get the following errors:

Msg 21531, Level 16, State 1, Procedure sp_MSmerge_alterschemaonly, Line 45
The DDL statement cannot be performed at the Subscriber or Republisher.

Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 181
The DDL operation failed inside merge DDL replication manipulation.

Msg 3609, Level 16, State 2, Procedure usp_Anniversary_upd, Line 21
The transaction ended in the trigger. The batch has been aborted.

Does this mean it can only be changed at the publisher ?

Bruce

correct. If you want to make schema changes at the subscriber, you need to set @.replicate_ddl to false in sp_addmergepublication.|||

Schema changes cannot be made at the subscriber. They have to come from the Publisher.

Message: correct. If you want to make schema changes at the subscriber, you need to set @.replicate_ddl to false in sp_addmergepublication.

I believe Greg meant "publisher only" instead of "subscriber" in the above statement.

|||

Hi

Just to clarify this.....

1. You cannot change it at the subscriber, irrespective of whether @.replicate_ddl is set to 0 or 1 ?

2. If @.replicate_ddl is set to 1, then changing the proc on the publisher will result in the proc being changed at the subscriber next time it is synchronised (if a published article)

Is this correct ?

I ask, because @.replicate_ddl is set to 1, but I get that error mentioned earlier if I try and change it at the subscriber.....

Thanks
Bruce

|||

1. you're correct, i was wrong in my earlier post.

2. correct.

Error when attempting to upgrade MSDE to Express using command line /UPGRADE

When attemping to install SQL 2005 Express using the following command line arguments

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE

or

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD

the following error occurs.

Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

The following version and editions have been verified.

1. .NET 2.0 installed

2. Windows XP SP2

3. MSDE 8.00.2039(SP4)

4. all MSDE databases are owned by sa

5. Instance and SQLAgent running under user that is member of Administrators

What are the possible reasons this error is occurring?

Hi gafrank,

Did you ever resolve this issue?

Mike

|||Yes. Thank you.

Error when attempting to upgrade MSDE to Express using command line /UPGRADE

When attemping to install SQL 2005 Express using the following command line arguments

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE

or

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD

the following error occurs.

Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

The following version and editions have been verified.

1. .NET 2.0 installed

2. Windows XP SP2

3. MSDE 8.00.2039(SP4)

4. all MSDE databases are owned by sa

5. Instance and SQLAgent running under user that is member of Administrators

What are the possible reasons this error is occurring?

Hi gafrank,

Did you ever resolve this issue?

Mike

|||Yes. Thank you.

Error When Attaching Database

Hello Everyone,

I am very new to SQL and just completed an install of SQL 2005 Express. After install, I downloaded the Adventure Works database and attempted to attach through both the Object Browser (right-click 'Databases'>'Attach') and by running the script that is located on the SQL download page where I got the Adventure Works db.

Here's the error that I get:

"Could not find row in sysindexes for database ID 8, object ID 1, Index ID 1. Run DBCC CHECKTABLE on sysindexes."

I have attempted to go through the help files, but unfortunately the above message is too cryptic for me and I have no idea what it's telling me.

Can someone help?

Thanks!!

YOu can either use the attach method OR create the database with the scripts. There is no need to execute both, as they will end up both with a working Adventureworks database. I always prefer to execute the script as I am able to have a hand on the scripts first :-)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Thank you for the help, Jens.

For what it's worth, I mentioned in my post that I tried both methods of attaching the database because neither of them worked. However, I have discovered why they didn't work:

When I went the Visual Studio page earlier this evening, I chose to install the SQL Server Express Tools thinking that this would give me the total installation including the SQL database engine. Apparently I was wrong. When choosing this option, what I got was the Management Studio and the Business Intelligence Development Studio. I was further led into thinking that I had everything I needed because I currently have the trial edition of SQL Server 2000 Enterprise Edition installed (the books I use in my SQL class are written in ANSI 92 so we only use 2000)...i'm sure you can imagine what happened after opening Management Studio for the first time - I get a connection to my SQL 2000 server complete with all of the databases I had installed over there. VERY CONFUSING if I do say so myself.

What I ultimately had to do was go back to the Visual Studio Express site and download the SQL 2005 Express engine and then install a new named instance. After I did this, I was able to then download the Adventure Works database and attach it successfully.

Not bad for a newbie, eh?!

I have always found SQL confusing which is why I saved it for last in my studies. This is my opinion here so take it for what it's worth - but if Microsoft wants more hobbyists and folks who are curious about IT to download SQL Express, then they need to better clarify and explain the difference between the various download options and the absolute importance of installing the SQL Express engine first. I can just imagine some people out there getting very frustrated and giving up completely.

I hope this helps some folks.

Thanks!!

|||

Hi Dear,

I got the same problem while attaching my database. Actully I received mdf and ldf file which was created in sql 2005. But I was not aware of that. Reading your post help me.

Thanks a lot.

Error When Attaching Adventure Works Database

Hello Everyone,

I am very new to SQL and just completed an install of SQL 2005 Express. After install, I downloaded the Adventure Works database and attempted to attach through both the Object Browser (right-click 'Databases'>'Attach') and by running the script that is located on the SQL download page where I got the Adventure Works db.

Here's the error that I get:

"Could not find row in sysindexes for database ID 8, object ID 1, Index ID 1. Run DBCC CHECKTABLE on sysindexes."

I have attempted to go through the help files, but unfortunately the above message is too cryptic for me and I have no idea what it's telling me.

Can someone help?

Thanks!!

YOu can either use the attach method OR create the database with the scripts. There is no need to execute both, as they will end up both with a working Adventureworks database. I always prefer to execute the script as I am able to have a hand on the scripts first :-)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Thank you for the help, Jens.

For what it's worth, I mentioned in my post that I tried both methods of attaching the database because neither of them worked. However, I have discovered why they didn't work:

When I went the Visual Studio page earlier this evening, I chose to install the SQL Server Express Tools thinking that this would give me the total installation including the SQL database engine. Apparently I was wrong. When choosing this option, what I got was the Management Studio and the Business Intelligence Development Studio. I was further led into thinking that I had everything I needed because I currently have the trial edition of SQL Server 2000 Enterprise Edition installed (the books I use in my SQL class are written in ANSI 92 so we only use 2000)...i'm sure you can imagine what happened after opening Management Studio for the first time - I get a connection to my SQL 2000 server complete with all of the databases I had installed over there. VERY CONFUSING if I do say so myself.

What I ultimately had to do was go back to the Visual Studio Express site and download the SQL 2005 Express engine and then install a new named instance. After I did this, I was able to then download the Adventure Works database and attach it successfully.

Not bad for a newbie, eh?!

I have always found SQL confusing which is why I saved it for last in my studies. This is my opinion here so take it for what it's worth - but if Microsoft wants more hobbyists and folks who are curious about IT to download SQL Express, then they need to better clarify and explain the difference between the various download options and the absolute importance of installing the SQL Express engine first. I can just imagine some people out there getting very frustrated and giving up completely.

I hope this helps some folks.

Thanks!!

|||

Hi Dear,

I got the same problem while attaching my database. Actully I received mdf and ldf file which was created in sql 2005. But I was not aware of that. Reading your post help me.

Thanks a lot.

Error Updating Installed Files

Well I need to know HOW TO REMOVE MANUALLY every pieace of the Database Services for my SQL Server Express CTP previous installation because the final release won't let me update this Database Services, any suggestion besides removing manually the services? thank you all

You should be able to remove the CTP from the Add/Remove Programs window, have you tried that? Add/Remove is the only way to uninstall SQL Server.

Regards,

Mike Wachal

|||

yes I removed it first that way but the same problem, I googled a bit and I found that removing the whole directory I could solve this and I did it also deleted some registry keys that I dont remember which one ups anyway I guess the problem was the SQL Server directory thanks

|||

Good to hear you've gotten it figured out, thanks for posting back to the forum.

- Mike

|||

Hi

When I tried to install the SQL Server 2005 version I got the following error

The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation.

Can you please let me know how did you resolved this error.

Funny thing is I have nothing installed on the box except IIS(Internet Information Services) still getting this error. When I google it looks like all the people who face this error because they have beta installations on their boxes.

Thanks in Advance. Your reply may helps me a lot.

Kiran

Error Updating Installed Files

Well I need to know HOW TO REMOVE MANUALLY every pieace of the Database Services for my SQL Server Express CTP previous installation because the final release won't let me update this Database Services, any suggestion besides removing manually the services? thank you all

You should be able to remove the CTP from the Add/Remove Programs window, have you tried that? Add/Remove is the only way to uninstall SQL Server.

Regards,

Mike Wachal

|||

yes I removed it first that way but the same problem, I googled a bit and I found that removing the whole directory I could solve this and I did it also deleted some registry keys that I dont remember which one ups anyway I guess the problem was the SQL Server directory thanks

|||

Good to hear you've gotten it figured out, thanks for posting back to the forum.

- Mike

|||

Hi

When I tried to install the SQL Server 2005 version I got the following error

The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation.

Can you please let me know how did you resolved this error.

Funny thing is I have nothing installed on the box except IIS(Internet Information Services) still getting this error. When I google it looks like all the people who face this error because they have beta installations on their boxes.

Thanks in Advance. Your reply may helps me a lot.

Kiran

Error trying to open Reporting Configuration Tool

I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:

SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.

My only options are to Debug or Close.

I'm not sure why I am getting this error. Can anyone help?

Thanks,

Amanda

mandercruso wrote:

I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:

SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.

My only options are to Debug or Close.

I'm not sure why I am getting this error. Can anyone help?

Thanks,

Amanda

I would recommend reinstalling the reporting services components of SQL.

|||

thanks. how can I just reinstall that component? I've uninstalled and reinstalled SQL Server 2005 Express thinking that would solve the problem, but it didn't....|||

Hmmm...If reinstalling the whole kit and kabudle didn't solve it then I would doubt that reinstalling just that component would.

It almost sounds like an operating system conflict. What does it do when you click debug?

|||

it gives me the following error:

an unhandled exception ('System.ComponentModel.Win32Exception') occurred in RSConfigTool.exe [7680].

Then it gives me the possible debuggers to choose from

|||Have you applied SP1 or SP2?

|||

Just downloaded SP2 with Advanced Options. Not sure if it matters but I have SQL Server 2000 on my machine... Visual Studio 2003 and 2005...

|||OK so you have yet to install SP2? Let us know if you still get the error after installing it.

|||

No, I meant, that's what I have originally downloaded and installed.

|||

bump... still having this problem. Does anyone know what's wrong?

Error SQL Server 2005 Express Error: 70347(0x112cb) WMI

Que tal. Al iniciar el instalador SQL Server 2005 Express me saca el error "System Configuration Checker cannot be executed due to WMI configuration on te machine..." Si alguien sabe como solucionarlo agradeceria se ayuda. Gracias.

Hi,

This is an English language forum, please translate you questions before you post them. Based on the error message, you have a problem with WMI on your computer, this is a Windows component. You can find information on diagnosing and repairing WMI problems at http://windowsxp.mvps.org/repairwmi.htm.

Mike