How can I connect to Microsoft SQL Server 2005 CTP with Microsoft SQL Server 2005 Express Manage

I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally
but when I connect to Microsoft SQL Server 2005 CTP, I failed! when I open SQL Configuration Manager,
I find the SQL Server had been running, after I opened "Attribute" window, I find "This account" box had been checked,
and "NT AUTHORITY\NETWORK SERVICE" was displayed in Account Name edit box, "**********" was displayed in "Password" edit box.

I think that the reason I can't connect to Microsoft SQL Server 2005 CTP is that I can't know the name of SQL Server 200, account, password.
right? In Microsoft SQL Server 2000 I can find the name of server from "Service Manager" and default accunt is "SA", the default password is blank.
but I can't find it in Microsoft SQL Server 2005. Any more, when I open "Express Manager", there are two radio button, "Windows Authentication" and "SQL Server Authentication",
which one will I choose? Does "Server Instance" point the name of SQL Server 2000? or Does "Server Instance" point the name of my computer?

Hi,

Try connecting with '.\SqlExpress' as the instance name. If you haven't specified a username and password then, windows authentication is the mode of logging into Sql2005...

cheers,

Paul June A. Domag

|||Hi,

You can also enable SQL Authentication. Follow instructions to enable it:
Enabling SQL Authentication

STEP1:
You need to enable SQL Authentication on the machine. This is complex in SQLExpress and you need to edit the registry. Copy the following lines of text onto a Notepad and save it with extention .REG.
-COPY BELOW
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer]
"LoginMode"=dword:00000002
-COPY TILL THIS
STEP2: Double Click on the .REG file to change the registry. This change the Authentication Mode to enable SQL Authentication.

STEP3: Restart the SQL Server Express Service or reboot the machine for registry change to take effect.

Next, you need to add a user with SQLLogin.
To do this: Login to SQLExpress using Express Manager and run the script below:
-
USE MASTER
sp_addLogin 'newuser', 'newuser@.123'
GO
sp_addsrvrolemember 'newuser', 'sysadmin'
GO
-
Once this is done, you can logon with the username/password combination.

Regards,
Vikram

|||Hi Vikram,
thank you for this post - was of great help !

Regards,
Fabian
|||Hey this is very cool! But I have a question- in the past it seems these settings follows each individual SQL Server Instance, but now it seems its a global setting as it does not require any instance specific configuration?|||

Help!!!

Please help me sort through this mass of web server information and configuration. I don't know where to begin?

l

|||

Thank you, I am a novice in this area.

Charles

|||

Hi William,

No, configuration is still instance specific. Each instance has a seperate registry hive in the format:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x
where x is some integer.

The mapping from MSSQL.x to the actual instance name can be found in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names.

Il-Sung.

How can I connect to Microsoft SQL Server 2005 CTP with Microsoft SQL Server 2005 Express Ma

I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally
but when I connect to Microsoft SQL Server 2005 CTP, I failed! when I open SQL Configuration Manager,
I find the SQL Server had been running, after I opened "Attribute" window, I find "This account" box had been checked,
and "NT AUTHORITY\NETWORK SERVICE" was displayed in Account Name edit box, "**********" was displayed in "Password" edit box.

I think that the reason I can't connect to Microsoft SQL Server 2005 CTP is that I can't know the name of SQL Server 200, account, password.
right? In Microsoft SQL Server 2000 I can find the name of server from "Service Manager" and default accunt is "SA", the default password is blank.
but I can't find it in Microsoft SQL Server 2005. Any more, when I open "Express Manager", there are two radio button, "Windows Authentication" and "SQL Server Authentication",
which one will I choose? Does "Server Instance" point the name of SQL Server 2000? or Does "Server Instance" point the name of my computer?

Hi,

Try connecting with '.\SqlExpress' as the instance name. If you haven't specified a username and password then, windows authentication is the mode of logging into Sql2005...

cheers,

Paul June A. Domag

|||Hi,

You can also enable SQL Authentication. Follow instructions to enable it:
Enabling SQL Authentication

STEP1:
You need to enable SQL Authentication on the machine. This is complex in SQLExpress and you need to edit the registry. Copy the following lines of text onto a Notepad and save it with extention .REG.
-COPY BELOW
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer]
"LoginMode"=dword:00000002
-COPY TILL THIS
STEP2: Double Click on the .REG file to change the registry. This change the Authentication Mode to enable SQL Authentication.

STEP3: Restart the SQL Server Express Service or reboot the machine for registry change to take effect.

Next, you need to add a user with SQLLogin.
To do this: Login to SQLExpress using Express Manager and run the script below:
-
USE MASTER
sp_addLogin 'newuser', 'newuser@.123'
GO
sp_addsrvrolemember 'newuser', 'sysadmin'
GO
-
Once this is done, you can logon with the username/password combination.

Regards,
Vikram

|||Hi Vikram,
thank you for this post - was of great help !

Regards,
Fabian|||Hey this is very cool! But I have a question- in the past it seems these settings follows each individual SQL Server Instance, but now it seems its a global setting as it does not require any instance specific configuration?|||

Help!!!

Please help me sort through this mass of web server information and configuration. I don't know where to begin?

l

|||

Thank you, I am a novice in this area.

Charles

|||

Hi William,

No, configuration is still instance specific. Each instance has a seperate registry hive in the format:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x
where x is some integer.

The mapping from MSSQL.x to the actual instance name can be found in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names.

Il-Sung.

How can I connect to Microsoft SQL Server 2005 CTP with Microsoft SQL Server 2005 Express Ma

I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally
but when I connect to Microsoft SQL Server 2005 CTP, I failed! when I open SQL Configuration Manager,
I find the SQL Server had been running, after I opened "Attribute" window, I find "This account" box had been checked,
and "NT AUTHORITY\NETWORK SERVICE" was displayed in Account Name edit box, "**********" was displayed in "Password" edit box.

I think that the reason I can't connect to Microsoft SQL Server 2005 CTP is that I can't know the name of SQL Server 200, account, password.
right? In Microsoft SQL Server 2000 I can find the name of server from "Service Manager" and default accunt is "SA", the default password is blank.
but I can't find it in Microsoft SQL Server 2005. Any more, when I open "Express Manager", there are two radio button, "Windows Authentication" and "SQL Server Authentication",
which one will I choose? Does "Server Instance" point the name of SQL Server 2000? or Does "Server Instance" point the name of my computer?

Hi,

Try connecting with '.\SqlExpress' as the instance name. If you haven't specified a username and password then, windows authentication is the mode of logging into Sql2005...

cheers,

Paul June A. Domag

|||Hi,

You can also enable SQL Authentication. Follow instructions to enable it:
Enabling SQL Authentication

STEP1:
You need to enable SQL Authentication on the machine. This is complex in SQLExpress and you need to edit the registry. Copy the following lines of text onto a Notepad and save it with extention .REG.
-COPY BELOW
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer]
"LoginMode"=dword:00000002
-COPY TILL THIS
STEP2: Double Click on the .REG file to change the registry. This change the Authentication Mode to enable SQL Authentication.

STEP3: Restart the SQL Server Express Service or reboot the machine for registry change to take effect.

Next, you need to add a user with SQLLogin.
To do this: Login to SQLExpress using Express Manager and run the script below:
-
USE MASTER
sp_addLogin 'newuser', 'newuser@.123'
GO
sp_addsrvrolemember 'newuser', 'sysadmin'
GO
-
Once this is done, you can logon with the username/password combination.

Regards,
Vikram

|||Hi Vikram,
thank you for this post - was of great help !

Regards,
Fabian|||Hey this is very cool! But I have a question- in the past it seems these settings follows each individual SQL Server Instance, but now it seems its a global setting as it does not require any instance specific configuration?|||

Help!!!

Please help me sort through this mass of web server information and configuration. I don't know where to begin?

l

|||

Thank you, I am a novice in this area.

Charles

|||

Hi William,

No, configuration is still instance specific. Each instance has a seperate registry hive in the format:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x
where x is some integer.

The mapping from MSSQL.x to the actual instance name can be found in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names.

Il-Sung.

How can I check the version of reporting services installed?

Hi, all here,

Would anyone here please guide me how can I check the version of reporting services installed? My problem is in my virtual machine, both SQL Server and SQL Server 2005 are installed, but I can create report in the vistual studio 2005 IDE, but cant deploy it to the reporting server database, in addition, I cant connect to reporting services database in SQL Server 2005 management studio.

Is it possible to install two different versions of reporting services in the same virtual machine? Please anyone here give me some advice for that. Thanks a lot.

With best regards,

Yours sincerely,

Run the site http://localhost/reportserver you will find the version number somewhere on the site indicating that 8.x is 2k and 9.x is 2k5.

How to: Install Reporting Services Side-by-Side an Earlier Version (side by side)
http://msdn2.microsoft.com/en-us/library/ms143520.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||How do you know what service pack is installed? Both 2000 and 2005 have multiple service packs out.|||

Hi,

see:

http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

How can I check the version of reporting services installed?

Hi, all here,

Would anyone here please guide me how can I check the version of reporting services installed? My problem is in my virtual machine, both SQL Server and SQL Server 2005 are installed, but I can create report in the vistual studio 2005 IDE, but cant deploy it to the reporting server database, in addition, I cant connect to reporting services database in SQL Server 2005 management studio.

Is it possible to install two different versions of reporting services in the same virtual machine? Please anyone here give me some advice for that. Thanks a lot.

With best regards,

Yours sincerely,

Run the site http://localhost/reportserver you will find the version number somewhere on the site indicating that 8.x is 2k and 9.x is 2k5.

How to: Install Reporting Services Side-by-Side an Earlier Version (side by side)
http://msdn2.microsoft.com/en-us/library/ms143520.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||How do you know what service pack is installed? Both 2000 and 2005 have multiple service packs out.|||

Hi,

see:

http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

How can I check if SQL Server Management Studio is installed?

How can I check if SQL Server Management Studio is installed?

[Start] \ [All Program] \ [Microsoft SQL Server 2005] \ [SQL Server Management Studio]

It is either there or not.

The default install does NOT include the client tools. If if is not listed, then using the install media, run Setup again, and select the Client Tools.

|||

Sorry.

How can I check programmatically if SQL Server Management Studio is installed?

|||

Either look in this location

"{installLocation}\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlwb.exe"

or check this Registry entry using xp_regread

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Applications\sqlwb.exe

sql

How can i check if Notification Services engine components is insalled or not?

I have installed the SQL Server 2005, including in the installation the notification serviceis, I want to check that Notification Services engine components is insalled, how can i do that?!

Do you see Notification Services in the Object Browser of SSMS? You can right click on it, select List Versions, and see more information.

HTH...

How can I change the "read-only" database for add, edit and delete users?

Sorry about my English, it is not my natural language and thanks for your help. I have installed the Personal Site Starter Kit, everything work perfect except register users. When a new user try to register as a new user he receives an error, caused because the database is "read-only". In IIS the database has read and writing permissions and the directories where the aplication is. How can I change the database permissions?

Server Error in '/personalweb' Application.

---

Failed to update database "C:\INETPUB\WWWROOT\PERSONALWEB\APP_DATA\ASPNETDB.MDF" because the database is read-only.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Failed to update database "C:\INETPUB\WWWROOT\PERSONALWEB\APP_DATA\ASPNETDB.MDF" because the database is read-only.

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): Failed to update database "C:\INETPUB\WWWROOT\PERSONALWEB\APP_DATA\ASPNETDB.MDF" because the database is read-only.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857466 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735078 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3612 System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305 System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +105 System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +453 System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +149 System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Hi,

From looking at the error message, sounds like yourASPNETDB.mdf and ASPNETDB_log.ldf files has readonly attribute. You need to unchecked the Read-Only attribute and then add a blank app_offline.htm file to your c:\INETPUB\WWWROOT\PERSONALWEB and delete it right afterward.

Hope that helps,

Lan

How can I change sql server name 2000

How can I change sql server name 2000? It was accidently installed using "local" as name

Thank you

Hi there,

Perhaps this link could be of assistance:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

Although....By reading your question, it seems that you installed a default instance of SQL Server, which should show up as (local) in the Enterprise Manager console running on your server machine. However, clients who want to connect to your SQL Server will need to use the name (or IP) of the machine the server resides on in order to connect.

If you installed a default instance but want to change the name so that it looks like a named instance, I'm not sure whether you can or not (I've never tried it). Anyway, if you have a default instance and need a named instance, you could always just install another instance on your machine (if that's an option).

Hope that helps a bit, but sorry if it doesn't

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always th
e
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:

> we have a server installed SQL 2005 with Microsoft Action Pack Product Key
,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.
Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always the
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:

> we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always the
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:
> we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>sql

How can I be sure that MSDE is installed and running

How can I check to be sure that the MSDE is installed properly and that it is running?

Should I be able to see the Service Manger in the tray?

Thank you,Check it in task manager under the processes tab.

How can I be assured that I do have SP1 applied correctly in SQL 2005 Developer Edition

I installed my SQL 2005 Developer edition and applied the SP1. I didn’t have a time to wait the installation to complete (I needed to reboot) so I cancelled the SP1 which was downloaded from Windows Update.

Now, my development PC says that SQL 2005 SP1 is applied but I am not sure if it’s applied correctly. I tried to reinstall SP1 in order to be assured but I can’t get it reinstalled. I get error message saying that you already have SP1 2047 ENU applied.

I just don’t want (have a time) to troubleshoot some possible upcoming issues in development because of this. So, how can I be assured that I do have SP1 applied correctly?

At what stage you have to rebooted the box?

if this is used for a testing on production, then its better to resintall afresh to avoid any spurious errors in future.

Run SELECT @.@.VERSION and see the results.

|||

Yes. 9.00.2047 is the SQL Server 2005 SP1 version. You can verify the following items to get more confidence.

1. Add/Remove Program in control panel to check the status of SQL Server 2005.

2. Go to registry keys HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup to check the version.

3. You can check the file version of %ProgramFiles%Microsoft SQL Server\MSSQL.<instance id>\MSSQL\Binn\sqlservr.exe.

|||

I try to uninstall the SP1 but its not possible, so I guess in order to be safe I should uninstall the SQL 2005 developer edition completely and reinstall it and apply the batch again.

It looks all good in SQL site, but SQL reported the SP1 applied and Microsoft Update reported the SP1 cancelled. This is a bit wired, so I going to do the reinstallation in order avoid any spurious errors in future.

Thanks folks....You great....

Alexander

How can I access SQL Server Compact Edition with SQL Server Management Studio Express?

Hello,

I just installed SQL Server Compact Edition, since I am considering using it instead of SQL Server Express for a local database in my application. The documentation mentioned that I could use SQL Server Management Studio Express to connect to the Compact Edition and create and manipulate databases.

To try to connect, I run Management Studio and bring up the "Connect to Server" dialog. Unfortunately, the pull-down list of "Server name"s does not include the SQL Server Compact Edition server. I do not know how to type in the server name manually, so I cannot connect.

To install Compact Edition, I downloaded it and ran "SQLServerCE31-EN.msi". This installed, and I assume registered, a number of DLLs in "C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\".

Is there perhaps an additional step that I left out to complete the installation?

Might I need an upgrade to some other components? My Management Studio Version is:

- Microsoft SQL Server Management Studio Express 9.00.2047.00

I would appreciate any help you can provide.

Thank you,

WTW

The support for SQL Server 2005 Compact Edition was added in Microsoft SQL Server Management Studio Express (SSMSE). SSMSE is available for download at:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

SSMSE shipped with SQL Server 2005 SP2. SQL Server 2005 SP2 information is at

http://technet.microsoft.com/en-us/sqlserver/bb426877.aspx#3

Regards

Ambrish

|||

WTW,

I've written a blog post about this, you can see it at http://arcanecode.wordpress.com/2007/04/11/create-a-sql-server-compact-edition-database-using-sql-server-2005-management-studio/ . I've also written an article that describes all the components you'll want to install to make everything work right, http://arcanecode.wordpress.com/2007/04/24/sql-server-2005-compact-edition-important-component/ .

You might also want to check the Arcane Lessons page for more SSCE tutorials.

Arcane

|||

Thanks for your reply. I uninstalled SSMSE and downloaded and installed it again. However, I still cannot access a SQL Server 2005 Compact Edition database.

When I bring up the "Connect to Server" dialog, the "Server Type" is fixed at "Database Engine", and I cannot determine how to change it. I've tried most of the menus and buttons, and I cannot find a setting for this.

I am missing some other component or configuration option?

Thanks for your help.

WTW

|||

Thanks for your very helpful reply. Thanks to your blog, I now have all of the proper components installed to make Compact Edition work properly. Your blog was the only place where I have found a complete list of all of the necessary components.

I have even purchased the E-book that you recommended, and it is very helpful.

However, I still am not able to access a Compact Edition database through SQL Server Management Studio Express. When I bring up the "Connect to Server" dialog, the "Server Type" is fixed at "Database Engine", and I cannot determine how to change it to Compact Edition or something similar.

The E-book demonstrates how to access a Compact Edition database through Management Studio. However, it shows a "Connect" menu in Management Studio that does not exist on my version. According to the E-book screen shots, the "Connect" menu should allow you to select "SQL Server Mobile", which will then bring up a "Connect to Server" dialog that shows a "Server Type" of "SQL Server Mobile". The next line allows selection of a "Database file" instead of a "Server name".

My version of Management Studio does not have the "Connect" menu. I even tried reinstalling Management Studio from the Microsoft website. However, I discovered that I already had the latest version, 9.00.2047.00.

I would appreciate any additional help you can provide.

Regards,

WTW

|||In typical microsoft style, the documentation is horrible on this. I was only able to get it to work by installing SP2 of SSMSE (of which there is no mention on the regular SSMSE download page) at:

http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en

and the SQL CE SDK found at:

http://www.microsoft.com/downloads/details.aspx?familyid=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en

You will know you have SP2 of SSMSE installed if you version is 9.00.3042.00
|||

SP2 did the trick. Thank you so much.

Regards,

WTW

How and where should I create a mdf file if I installed a sql server 2005(Developer EditioN)

hi:

I am a newbie to sql server 2005 (developer edition). Now I installed both sql server and VS 2005 professional edition on my machine.

I just what to know how and where should I create a mdf file on my server or .net window project because I try to combine to it from a window application. Should I use the sql server management studio or the Visual Studio 2005 ? What is the generate steps to create one?

I am completely confused. Please help me, I cannot find related on line source.

Thank you, thank you

bigheadjj

That depends wheter you want to use a user instance with a SQL Server database or a SQL Server hosted instance. The Visual Studio Database can support both, whether a user or a server instance. Did you have the concept of a user instance or a server instance ? If not, I would suggest you reading the principles of that in the web.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Even if VS 2005 can connect to the server and create database files, I recommend that you use the SQL Server client tools (SSMS, sqlcmd, etc.) This gives you a good understanding of what is happening on the database side. Plus, using the SQL Server client tools, you can configure other database options which cannot be done using VS 2005|||

Jens

Thank you very much. I will start to read related principles as you suggested.

|||

bass_player

thank you for helping me. Your recommendation is very helpful.

Hotfix Versions

Hi,
Is there someplace where I can find a definitve reference as to which
hotfix has been installed and relate that to the version shown by
'SELECT @.@.VERSION' post SQL Server 2000 SP3?
Most references I have found stop at SP3.
Many thanks
Simonhttp://www.aspfaq.com/show.asp?id=2160
Jacco Schalkwijk
SQL Server MVP
"Simon Adams" <warmtea@.hotmail.com> wrote in message
news:c34aa6c2.0502160534.4f3e04f6@.posting.google.com...
> Hi,
> Is there someplace where I can find a definitve reference as to which
> hotfix has been installed and relate that to the version shown by
> 'SELECT @.@.VERSION' post SQL Server 2000 SP3?
> Most references I have found stop at SP3.
> Many thanks
> Simon

Hotfix Versions

Hi,
Is there someplace where I can find a definitve reference as to which
hotfix has been installed and relate that to the version shown by
'SELECT @.@.VERSION' post SQL Server 2000 SP3?
Most references I have found stop at SP3.
Many thanks
Simon
http://www.aspfaq.com/show.asp?id=2160
Jacco Schalkwijk
SQL Server MVP
"Simon Adams" <warmtea@.hotmail.com> wrote in message
news:c34aa6c2.0502160534.4f3e04f6@.posting.google.c om...
> Hi,
> Is there someplace where I can find a definitve reference as to which
> hotfix has been installed and relate that to the version shown by
> 'SELECT @.@.VERSION' post SQL Server 2000 SP3?
> Most references I have found stop at SP3.
> Many thanks
> Simon

Hotfix Versions

Hi,
Is there someplace where I can find a definitve reference as to which
hotfix has been installed and relate that to the version shown by
'SELECT @.@.VERSION' post SQL Server 2000 SP3?
Most references I have found stop at SP3.
Many thanks
Simonhttp://www.aspfaq.com/show.asp?id=2160
--
Jacco Schalkwijk
SQL Server MVP
"Simon Adams" <warmtea@.hotmail.com> wrote in message
news:c34aa6c2.0502160534.4f3e04f6@.posting.google.com...
> Hi,
> Is there someplace where I can find a definitve reference as to which
> hotfix has been installed and relate that to the version shown by
> 'SELECT @.@.VERSION' post SQL Server 2000 SP3?
> Most references I have found stop at SP3.
> Many thanks
> Simon

Hotfix on sp2

Hello,

Just want to know if anybody else has problems with the hotfix ?

I have a sqlserver 2005 on my desktop.

I installed the sp2 before 5th march.

Recently Microsoft changed the sp2 and released a hotfix for sp2 installed(downloaded) before 5th march.

I installed the hotfix but it failed to update the sqlserver engine.

Very weird.

I uninstalled sqlserver 2005, applied the new sp2 (which was smaller compared with previous one)

Today i still received a critical update in windows update.

I installed it, but i still don't trust these updates.

How can i investigate all went well ?

Go to Add/Remove Programs, click on the SQL 2005 entry, click Remove, and then Change. This will show a nice report at the component level and include the versions for each. If they are all at 3152, then your machine is up to date with the cumulative hotfix. If not, go grab it here:

http://support.microsoft.com/kb/933097

Thanks,
Sam Lester (MSFT)