Cn not do anything with my sql server, everything i trt to do i get this message, user does not have permision, etc, ,
I am running windows Vista Business, SQL SERVER 2005
so what going on here
View Complete Post
using (SqlConnection sqlConnection = new SqlConnection("Data Source=" + session["DWSERVER"] + ";Initial Catalog=master;Integrated Security=SSPI;"))
ServerConnection svrConnection = new ServerConnection(sqlConnection);
Server server = new Server(svrConnection);
string script = File.ReadAllText(session["INSTALLLOCATION"] + @"Sources\DW.sql");
script = script.Replace("[SSASSERVER]", session["SSASSERVER"]);
script = script.Replace("[DWSERVER]", session["DWSERVER"]);
script = script.Replace("[DBSERVER]", session["DBSERVER"]);
script = script.Replace(&q
So, we have an application that we've written to leverage SQL Express 2008 R2 - which our setup installs on the command line using the following instructions:
The code that does the installation can be found here:
//Path to the SQL Installation files
string strSQLPath =
//If we're on a 64-bit OS use the 64 bit setup
if (Wow.Is64BitOperatingSystem ==
I'm trying to setup SSRS using the Reporting Services Configuration Manager. Everything seems to be working except the database creation. When I click on the Database (3rd option down) then Change Database I run through the wizard. Put
in proper SA credentials. Accept the defaults clicking next through and when it gets to running the script to create the data base I get the Error I pasted below. We do not have a G drive so I went into SSMS and changed the Default Database settings
to point to the F drive (where our other DBs reside) - I got that tip off of this forum but it didn't fix my issue. Any ideas what to try next? Do I need to stop and restart a service or something? Thanks for any help you guys can offer.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
I have created a setup application with SQLEXpress 2008 as a prerequisite. On test SQLExpress installs OK
after the application is installed it must create and install a database using a mixture of SMO and Scripting. I used SMO to add the current user (who is a Windows Administrator) as a Login to the SQL Express server.
Dim l As Login = New Login(srv, My.User.Name)
l.LoginType = LoginType.WindowsUser
l.DefaultDatabase = "MASTER"
It fails on srv.CreateDatabase with error message "permission denied in database MASTER"
this thread talks about converting the server to single user mode before adding a login
how is it possible to scrip this? there is no&nbs
I am loading sql server 2008 r2 developer edition into Windows Vista Home Basic. Product loads correctly with no error messages; except will not create database engine. And will not create integration services. When I try to open MMC, I will get error "MMC
could not initialize the snap-in. Product may not have been installed correctly."
I understand this is a known issue for SQL Server 2008 RD installing on Windows Vista? What is the workaround or fix? Hot fixes available for this issue from support.microsoft.com do not install on my Windows Vista Home Basic machine.
getting this error when I try to restore a .bak database to sqlexpress:
CREATE DATABASE permission denied in database 'master'.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 262)
I login to sqlserver mgmt studio using windows authentication. Getting this permission denied error whether I login to the PC as administrator or my user account.
What do I need to do to be able to restore a database into sqlexpress?
I'm using Visual Studio 2005 Pro and SQLExpress that comes with it.
I have my program running fine in XP Pro OS using a window user "Glen" (Computer administrator) with Administrator rights.ÃÂ This means that I installed VS 2005 using this window user "Glen"
I created anotherÃÂ windows user "TestUser" (Limited account) in the same physical PC.
I tried to run theÃÂ programÃÂ and on the part that I need to access SQL table, I got the error [CREATE DATABASE permission denied in database 'master']
At the same time while using "TestUser" and running sqlcmd (to check if I can connect to SQL), I also got errorÃÂ HResult 0x2, Level 16, State 1.
I read alot on MSDN discussions and related links but it seems that I can't get the solution that I need.
SO HERE ARE MY QUESTIONS :
1.ÃÂ Am I allowed to run my programÃÂ using user "TestUser" since SQL is installed using "Glen" windows user?
2.ÃÂ Do I need to add access rights to "TestUser" to allow the user to have CREATE rights? (Note : for security reason, I can add other access rights except Administrator)
Thanks in advance for all you help.
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003