I've installed SQL Server 2005 Express, MSSMSE, and SQL BOL and they seem to work. How can I change the default location of the DB's I create in this environment (and/or move them after I create them)?
Thanks!
Answered myself:
Right click the top line ("servers") in the MSSMSE TOC window > properties > database...there are the options
Hello,
I restored and renamed a client database from a backup file to my laptop (both SQL Express 2005) and noticed that no owner had been assigned. I set the db-owner to SA. This database will replace a local version of the same database that was created on my laptop. (The customer has entered data...)
When I start the dataset configuration wizard in VS2005 all tables appear twice in the list. Once with the original name and once with the prefix dbo. For example: Customer and dbo.Customer.
The tables with the dbo. prefix are marked with a Red Cross in the checkbox. Hovering over them display the error message: "Element .. in the dataset references an object missing from the database. "
The tables without the dbo. prefix are not marked. When I mark these tables VS2005 indicates that the table will be renamed to Customer1. The same issue applies to all the views in the database.
Is there a way to solve this problem without having to recreate the entire dataset? I'd rather not do that cause I added some queries to the dataset and they will be lost and have to be recreated.
Any help will be appreciated.
hi,
I could not reproduce the problem... even not assigning a valid db owner to the restored db, the VS designer did not present a doubled list of db objects...
I can only think verifying the user your login is bound is not member of the dbo schema... try smodifying the "default" user's schema to dbo as well...
regards
i using sql server Express, i want to change the default language from US-English to British English
Where and How?
If you have the SQL management Studio you can do that easily . Right click on the database and change the collation of the database.
HTH
Regards
hongcw83:
i using sql server Express, i want to change the default language from US-English to British English
Where and How?
Another option is to use the locale ID configuration so you change from US to UK as in the link below, that includes the collation change as noted by Smiling4ever. Hope this helps.
http://msdn2.microsoft.com/en-us/library/ms143508.aspx
|||You can?simply use sp_configure to change the default language setting, check this post:hi,
I'm having this application using the express way to create the dategridview by having the query string builder. However, my computer recently crashed and I have no idea to change the connection string. so when I load the whole windows application, I am unable to view the information that are supposed to be in the datagridview. however, it returned an exception.
after finding out the main culprit, I realised that the database is using the old sql server's login. since it is using the old database's login, therefore it is unable to log the information into the datagrid view.
Please help! Thanks.
I'm sorry to hear that your computer crashed. Did you mean to change connection strings for typed DataSet which you created via "Data Source Configuration Wizard"? If so, you only need to change the corresponding Data Connection in the Server Explorer, as all Typed DataSet generated by the wizard use connectionstrings defined in Data Connections. If you want to configure connection string for individual TableAdapter, you need to open the typed DataSet in Design view, and right click on the TableAdapter->choose Configure...->press Previous button untill you rearch the "Choose Your Data Connection" step.
Hope this helps.
|||thanks for the guide..I'll try and see if it works in other computer..
Cheers,
Joelle
I am not good endlish. I am thai.
I try to change authentication from win --> sql authen. I am use sql express and management tool.I am select at .\sqlexpress --> property -->security and change authentication from win authentication to sql authentication and click OK
after that re-connect and change to sql authentication but It not work.
Pls tell me How to change authentication.
Thank you for you help
Hi there,From your description it seems that you've changed the authentication mode successfully.
I would assume, then, that the problem has something to do with the SQL Server account you are using. So:
* What account are you using?
* Does it have a password that you might have forgotten to enter? (sorry about asking that)
What you could do, to test that everything is absolutely OK is switch back to Windows Authentication, log into your SQL Server instance and create a new SQL Server user (e.g. test_user) with no password (or you could set a password, up to you).
After doing that, disconnect from your sever and reconnect using SQL Server Authentication. Set the account as the one you just created and enter whatever password you set (or nothing if you set not password).
Hopefully you'll log in successfully.
Hope that helps a bit, but sorry if it doesn't
|||You have to restart the service.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Check out the Setup log, it will give specific information about what components are still installed. If those components are not listed in Add/Remove Programs, you can uninstall them using:
msiexec -x <product ID>
Product ID will be listed in the setup log. This problem is discussed in detail in several other posts in this forum and in the Setup forum if you need more information.
Mike
|||where would i find the setup log?Hi, We are trying to implement Service Broker between SQL Server Express and SQL Server on the Same machine and we are having problems with certificates. We are creating a certificate on SQL Server, backing up the certificate on a file system and then loading certificate on the SQL Server Express from the file and we are keep getting the following error: Msg 15208, Level 16, State 1, Line 1 The certificate, asymmetric key, or private key file does not exist or has invalid format.
Following script runs fine on SQL Server.
Code Snippet
use master
Create Master Key Encryption BY Password = '45Gme*3^&fwu';
BACKUP MASTER KEY TO FILE = 'C:\ServiceBroker\PrivateKeyMasterB.pvk'
ENCRYPTION BY PASSWORD = '45Gme*3^&fwu'
Create Certificate EndPointCertificateC
WITH Subject = 'C.Server.Local',
START_DATE = '06/01/2006',
EXPIRY_DATE = '01/01/2008'
ACTIVE FOR BEGIN_DIALOG = ON;
BACKUP CERTIFICATE EndPointCertificateC
TO FILE = 'C:\ServiceBroker\EndPointCertificateC.cer'
Following script runs on SQL Server Express:
Code Snippet
Create Certificate EndPointCertificateC
From FILE = 'C:\ServiceBroker\EndPointCertificateC.cer'
WITH PRIVATE KEY (
FILE = 'C:\ServiceBroker\PrivateKeyMasterB.pvk',
DECRYPTION BY PASSWORD = '45Gme*3^&fwu'
);
If we run the script other way around, it works fine. If we use the SQL Server on some other machine, the script works fine. But only on the same machine, it throws this error. We made sure the permissions and everything. Let us know if there is any work around or what are we doing wrong.
Any help is appreciated. Thank you,
This must be a permisssion issue. The SQL Server Express service account does not have access to the .cer and/or .pvk file.|||We did give permission to $SQLServerExpress to the folders where we generate the files. And all we are trying to perform this using sa account, I am not sure which other permission we are missing.
|||Folder permissions are not enough. The files created (*.cer and *.pvk) will be ACL-ed by the creator instance to prevent any other account access, overwriting any permsision inherited from the folder permissions. So if for instance the SQL Express is running as NETWORK SERVICE, or as a (domain) user account, then it will not be able to see the files. You must explicitly grant read permissions on the two created files. Why this work on all other machines is probably because on all other machines the SQL Express and the Enterprise instance run as the same account, but not on this machine.
The account you log in as ('sa') has no relevance, all that matter here is the service account.
Hi, We are trying to implement Service Broker between SQL Server Express and SQL Server on the Same machine and we are having problems with certificates. We are creating a certificate on SQL Server, backing up the certificate on a file system and then loading certificate on the SQL Server Express from the file and we are keep getting the following error: Msg 15208, Level 16, State 1, Line 1 The certificate, asymmetric key, or private key file does not exist or has invalid format.
Following script runs fine on SQL Server.
Code Snippet
use master
Create Master Key Encryption BY Password ='45Gme*3^&fwu';
BACKUP MASTER KEYTOFILE='C:\ServiceBroker\PrivateKeyMasterB.pvk'
ENCRYPTION BY PASSWORD ='45Gme*3^&fwu'
CreateCertificate EndPointCertificateC
WITH Subject ='C.Server.Local',
START_DATE ='06/01/2006',
EXPIRY_DATE ='01/01/2008'
ACTIVE FOR BEGIN_DIALOG =ON;
BACKUPCERTIFICATE EndPointCertificateC
TOFILE='C:\ServiceBroker\EndPointCertificateC.cer'
Following script runs on SQL Server Express:
Code Snippet
CreateCertificate EndPointCertificateC
FromFILE='C:\ServiceBroker\EndPointCertificateC.cer'
WITH PRIVATE KEY(
FILE='C:\ServiceBroker\PrivateKeyMasterB.pvk',
DECRYPTION BY PASSWORD ='45Gme*3^&fwu'
);
If we run the script other way around, it works fine. If we use the SQL Server on some other machine, the script works fine. But only on the same machine, it throws this error. We made sure the permissions and everything. Let us know if there is any work around or what are we doing wrong.
Any help is appreciated. Thank you,
This must be a permisssion issue. The SQL Server Express service account does not have access to the .cer and/or .pvk file.|||We did give permission to $SQLServerExpress to the folders where we generate the files. And all we are trying to perform this using sa account, I am not sure which other permission we are missing.
|||Folder permissions are not enough. The files created (*.cer and *.pvk) will be ACL-ed by the creator instance to prevent any other account access, overwriting any permsision inherited from the folder permissions. So if for instance the SQL Express is running as NETWORK SERVICE, or as a (domain) user account, then it will not be able to see the files. You must explicitly grant read permissions on the two created files. Why this work on all other machines is probably because on all other machines the SQL Express and the Enterprise instance run as the same account, but not on this machine.
The account you log in as ('sa') has no relevance, all that matter here is the service account.
I'm working on a C# 2008 project, when i add a CE Database to it, then publish the app, the installer wants to download and install the entire SQL Server Express product on the client machines. My understanding is that I should be able to embed this database right into the app, but it defeats the purpose to have the installer download and install the entire express product (the actual project is 1 meg).
Is this expected behavior? or am I doing something wrong?
SQL Express is NOT required for SQL Compact projects. You must have a reference to a .mdf file or similar in your project that triggers this requirement.|||I checked the prerequisite tab and sql express isnt even checked, i'll investigate further
Can I get: SQL Express with Advanced Services on a CD (or DVD)
I'm on DialUp so a download would take 24hr+.
I was able to get the MS .NET Framework 2.0 on DVD because an MVP took pity on me and was kind enough to give me the "Secret" URL to the correct Order Desk.
I'm hoping one of you knows the URL for this CD/DVD
Roger
Hi Roger,
We're working on CD images for SQL Server Express with Advanced Services in all the languages that SQL Server usually ships in. The English version is in final testing and should be available in a couple of weeks.
Thanks
|||Is this CD available yet ?
Roger
|||Hopefully this will reach Paul Randal
Paul,
Back in May you said you were working on a CD of SQL Server Express with Advanced Services.
Is it available yet?
Roger
Can I get: SQL Express with Advanced Services on a CD (or DVD)
I'm on DialUp so a download would take 24hr+.
I was able to get the MS .NET Framework 2.0 on DVD because an MVP took pity on me and was kind enough to give me the "Secret" URL to the correct Order Desk.
I'm hoping one of you knows the URL for this CD/DVD
Roger
Hi Roger,
We're working on CD images for SQL Server Express with Advanced Services in all the languages that SQL Server usually ships in. The English version is in final testing and should be available in a couple of weeks.
Thanks
|||Is this CD available yet ?
Roger
|||Hopefully this will reach Paul Randal
Paul,
Back in May you said you were working on a CD of SQL Server Express with Advanced Services.
Is it available yet?
Roger
Can I get: SQL Express with Advanced Services on a CD (or DVD)
I'm on DialUp so a download would take 24hr+.
I was able to get the MS .NET Framework 2.0 on DVD because an MVP took pity on me and was kind enough to give me the "Secret" URL to the correct Order Desk.
I'm hoping one of you knows the URL for this CD/DVD
Roger
Hi Roger,
We're working on CD images for SQL Server Express with Advanced Services in all the languages that SQL Server usually ships in. The English version is in final testing and should be available in a couple of weeks.
Thanks
|||Is this CD available yet ?
Roger
|||Hopefully this will reach Paul Randal
Paul,
Back in May you said you were working on a CD of SQL Server Express with Advanced Services.
Is it available yet?
Roger
I installed SQL Server 2005 Express Edition with Advanced Services with Service Pack 2 but catalogue Report Manager it was not installed. To me will not address under the reference http: // localhost/reports$SQLExpress since such catalogue is not present in IIS. In what there can be a problem?
Thank's
Hi,are you sure that Reporting Services is installed ? You will need to have IIS as a prerequisite before installing Reporting Services, otherwise it wwon′t be installed.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
yes, but I have't installed Report Manager 
.
Thank's for help!!
