Hi
I am a complete newbie here. I have spent hours trying to create a database - (even installed on XP and Vista) and I seem to not be able to create a database - it tells me that:
Create Database permission denied in database master - Microsoft SQL Server Error 262.
How to I enable these priviledges?
Do i need to regsiter the Server with the Enterprise Manager and how do I do that?
All help VERY gratefully received thanks Lister
Hi, I need urgent help with this problem because I am unable to do any database development due to it. I am using visual web developer express edition with sql server 2005 express edition. The problem is that when I try to create a database in the app_data folder I get the following error message: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed".
Regards, sandy
I had a fully functioning SQL 2005 Exp install until today. All of my DBs work, Reporting Services works. But today I went to add a new DB for a DotNetNuke installation. Everything I have tried fails with the same error:
*****************************************************
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'TEST'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A file activation error occurred. The physical file name 'G:TEST.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5105)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5105&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
*****************************************************
I have looked high and low for a solution only to come up empty handed. I only hope at this moment that someone here has seen this before.
Thanks
Jason
I've recently installed VB Express and SQL Server Express (including
Management Studio Express) on a laptop as well as a desktop PC.
Everything looks the same on both. I can create an SQL database
from VB without any problems on my laptop. However, when I try to
create a new SQL database from VB on my desktop, I get the following
message:
"Failed to generate a user instance of SQL Server due to a failure in
starting the process for the user instance. The connection will be
closed."
I've written a number of databases in Access, but never used SQL Server. This is about to drive my crazy.
Thanks.
Hello,I am attempting to send emails using T-SQL (in a SQLServerAgent Job)using the stored procedure sp_SendSMTPMail. I created the stored procusing the following script that I got off a post here on google.CREATE PROCEDURE sp_SendSMTPMail (@From varchar(255),@To varchar(8000),@Subject varchar(255),@Body varchar(8000),@cc varchar(8000) = NULL,@Bcc varchar(8000) = NULL)ASDECLARE @newmail intDECLARE @result int-- Create the CDONTS.Newmail objectEXEC @result = sp_OACreate 'CDONTS.NewMail', @newmail OUTIF @result <> 0BEGINPRINT 'Error creating object'EXEC sp_displayoaerrorinfo @newmail, @resultRETURNEND-- Check the Optional PropertiesIF not @cc = NULLBEGINEXEC @result = sp_OASetProperty @newmail, 'cc', @ccIF @result <> 0BEGINPRINT 'Error setting [cc] property'-- EXEC sp_displayoaerrorinfo @newmail, @resultRETURNENDENDIF not @Bcc = NULLBEGINEXEC @result = sp_OASetProperty @newmail, 'Bcc', @BccIF @result <> 0BEGINPRINT 'Error setting [Bcc] property'-- EXEC sp_displayoaerrorinfo @newmail, @resultRETURNENDEND--set the non-optional propertiesEXEC @result = sp_OASetProperty @newmail, 'From', @FromEXEC @result = sp_OASetProperty @newmail, 'To', @ToEXEC @result = sp_OASetProperty @newmail, 'Subject', @SubjectEXEC @result = sp_OASetProperty @newmail, 'Body', @Body-- Send the message...EXEC @result = sp_OAMethod @newmail, 'Send'IF @result <> 0BEGINPRINT 'Error sending message'-- EXEC sp_displayoaerrorinfo @newmail, @resultRETURNEND-- Destroy the object.EXEC @result = sp_OADestroy @newmailIF @result <> 0BEGINPRINT'Error destroying object'-- EXEC sp_displayoaerrorinfo @newmail, @resultRETURNENDGO______________________________________________This worked perfectly in testing at our office but when we shipped tothe client it produced the error 'Error creating object'. We sent theclient the script to create the sp_displayoaerrorinfo proc and got thefollowing error message.Error creating object-2147221005OLE Automation Error InformationHRESULT: 0x800401f3Source: ODSOLE Extended ProcedureDescription: Invalid class stringNow this suggested to me that the for some reason we were unable toreference the CDO library, or it wasn't installed. However they haveOutlook 2000 installed with CDO installed with it. I've had had themremove and reinstall the CDO library but that hasn't helped.Other thing I though of was a permission type problem. They are usingNT authentication for there logins into SQL server and are logged onthe server as Administrator who I would assume has all requiredpermissions.Any suggestions for either determining the cause of them problems or asolution?Thanks in advance.Bob.
View 3 Replies View RelatedHello,
I just recently installed SQL Express 2005 on a new OS which is on Vista Ultimate.
When I try to attach a database by clicking the add button, I receive this error:
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.SqlManagerUI.BrowseFolderHelper.GetBrowseStartPath(ISettingsStorage settingsStorage, ServerConnection serverConnection, Type controlType, String settingKey) at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.GetStartPath(String settingName) at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.buttonBrowse_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.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)
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteImmediate(String query) at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent) at Microsoft.SqlServer.Management.Smo.Environment.GetData() at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
===================================
The server principal "MyComputerKarl" is not able to access the database "model" under the current security context. (.Net SqlClient Data Provider)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
------------------------------Server Name: MyComputerSQLEXPRESSError Number: 916Severity: 14State: 1Line Number: 1
------------------------------Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
When I try to creat a new database I receive this error:
===================================
Create failed for Database 'TestDB'. (Microsoft.SqlServer.Express.Smo)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------Program Location:
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl() at Microsoft.SqlServer.Management.Smo.Database.Create() at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.ApplyChanges(Control marshallingControl) at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
===================================
CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
------------------------------Server Name: MyComputerSQLEXPRESSError Number: 262Severity: 14State: 1Line Number: 1
------------------------------Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
On my previous computer which had WinXp Pro I had no such problems
Any Help would be much appreciated
Thanks
Karl
I am using visual web developer with sqlserver2005 express edition. When I try to create a database in the App_Data folder through solution explorer I get the following error message:
Failed to generate a user instance of Sql Server due to a failure in starting the process for the user instance. The connection will be closed.
I am unable to create the database. Can anyone help in solving this problem?
Regards, Sandy
I have a network drive that is mapped as Z: on my local machine. When creating a new database, that drive does not show up in the list of available paths. If I try to hardcode the drive/path info, I get an error message: "The system cannot find the path specified."
View 1 Replies View Related
I am using SQL express and Visual web developer on windows Vista.
When I try to create a new database the following message appears.
CREATE DATABASE permission denied in database master (error 262)
I log on to my computer as an administrator.
Help appreciated
Prontonet
I saw a video on how its possible to create a local database so that when the application is being deployed, the mdf file will be deployed with it and will contain the enter data. The instructor(Beth Messi) showed that all I need to do is to add the .mdf file using the "Rightclick Project name in solution explorer > select add > add new item > then in the dialog that opens, select SQL database and click ok. I did this but the Visual Studio kept saying: "An error occored while extablishing a connection with the server. When connecting SQL Server 2005, this failure may have been caused by the fact that under the default settings of SQL Server does not allow remote connections. (Provider: Shared memory provider, error: 40 - could not open a connection to SQL Server)"
Honestly, I don't know how to go futher with this. The SQL server am using is the professional edition and I have been able to use it through Visual Studio to create Databases. It connects alright in that senario. Please I really need help here.
Hi,I have transactional replication set up on on of our MS SQL 2000 (SP4)Std Edition database serverBecause of an unfortunate scenario, I had to restore one of thepublication databases. I scripted the replication module and droppedthe publication first. Then did a full restore.When I try to set up the replication thru the script, it created thepublication with the following error messageServer: Msg 2714, Level 16, State 5, Procedure SYNC_FCR ToGPRPTS_GL00100, Line 1There is already an object named 'SYNC_FCR To GPRPTS_GL00100' in thedatabase.It seems the previous replication has set up these system viewsSYNC_FCR To GPRPTS_GL00100. And I have tried dropping the replicationmodule again to see if it drops the views but it didn't.The replication fails with some wired error & complains about thisviews when I try to run the synch..I even tried running the sp_removedbreplication to drop thereplication module, but the views do not seem to disappear.My question is how do I remove these system views or how do I make thereplication work without using these views or create new views.. Whyis this creating those system views in the first place?I would appreciate if anyone can help me fix this issue. Please feelfree to let me know if any additional information or scripts needed.Thanks in advance..Regards,Aravin Rajendra.
View 2 Replies View RelatedHello.
Our GIS group is working with SQL Server 2005 in conjunction with ESRI's ArcGIS software. SQL Server is being used as a test bed until we formally migrate our existing Microsoft Access mdb's over. So, at this time we are conducting various tests and have the freedom to "blow up" our databases.
We are currently testing ArcSDE Workgroup edition, which will only work with SQL Server Express (SSE). SSE will let us create spatial joins and relationships, while maintaining data integrity. So one possible workaround was to detach the database from SQL Server 2005 and then attach it to SSE. Unfortunately, we ran into a problem in re-attaching the database back to SQL Server 2005.
The exact steps are as follows:
Back up database using back up tool in SQL Server 2005.
Detached database from SQL Server 2005.
Attached database to SQL Server Express (hereafter SSE).
Created a table in database while it was attached to SSE.
Detached database from SSE.
Attempt to attach database to SQL Server 2005 failed
Successfully restored database in SQL Server 2005 using Restore tool.
Step number 6 above failed and generated the following error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLNRIS_SQL_Test.mdf'. (Microsoft SQL Server, Error: 5123)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476
Questions:
Why did I get this error?
Can incorrect or missing permission or ownership settings generate this kind of error?
When should one detach/attach a database?
I welcome your assistance and suggestions.
Hi all,
I'm new to .NET and VB2008 and trying to write my first database application. It runs fine on my development PC (Vista) but I decided to publish/install an early beta to my daughters XP computer and am getting an error reading: Unable to open database.
The CD drive on that pc has been giving us trouble so I deployed to a subdirectory on the dev pc and moved those files to a thumbdrive, copied to the same subdirectory on client pc and installed from there. I've installed it more than once, trying different paths for the installed version hoping that was the issue but have hit a wall. Can anybody help?
Thanks,
Dominic
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
got rid of my error about user login rights, it was all working yesterday. but for some reason i now get this error CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
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: CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
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): CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734995
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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
i have this in my web.config file <connectionStrings> <add name="ConnectionStringTest" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf;Integrated Security=SSPI;Connect Timeout=30;User Instance=False" providerName="System.Data.SqlClient" /> </connectionStrings> <appSettings /> <system.web> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. --> <compilation debug="true" /> <identity impersonate="true"/> and my asp connection string is <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringTest %>" SelectCommand="SELECT [entryID], [compID], [emailAddy], [answer] FROM [entry]"></asp:SqlDataSource> if i set user instance to true i get a user permission error. it says on sql server management that i have dbo rights on my database, but it wont let me put datareader or write on this login. any ideas? its driving me insane
Hi
I am new to SQL and unable to create a new database since I do not have enough priviliedges (error 262).
I do not understand this since the login username came from the hosting i am with.
How do I set my username login to allow me the ability to create a new database?
Replies are very gratefully received since i am going steadily nuts trying to solve this - thanks, Lister
I am trying to create a database in my application's installation folder and it will not create because the folder does not have the permissions for the service account added as full control. I can't figure out how to get the service account name in my program so that I can add it to the folder permissions. The service name is a long name and has the computer name and the SQL server name included in it. For example: SQLServer2005MSSQLUser$<Ccmputer Name>$SQLEXPRESS. I'm assuming this pattern is always followed. I guess my question is can I query the database for this information and then use it to add the appropriate permissions to my application's install folder?
View 1 Replies View RelatedI am trying to create a database and I manage to get the code right for dropping the database if it already exists and then createing the data file and log file. After this I try to set some options for the database with the following code
ALTER DATABASE MyDataWarehouse
SET RECOVERY SIMPLE,
ANSI_NULLS ON,
ANSI_PADDING ON,
ANSI_WARNINGS ON,
ARITHABORT ON,
CONCAT_NULL_YIELDS_NULL ON,
QUOTED_IDENTIFIER ON,
NUMERIC_ROUNDABORT OFF,
PAGE_VERIFY CHECKSUM,
ALLOW_SNAPSHOT_ISOLATION ON;
GO
But I get an error saying Incorrect syntax near 'CHECKSUM'.
I've just installed SQL Server Express and attempted to create my first database and received this error message :-(
Maybe this is a long shot, but can someone tell me what I've done wrong? Do I have a bad install or what?
Essentially I followed the steps below to create the database:
1. Started MS SQL Server Management studio Express
2. Right clicked on the Database folder
3. Selected "New Database..."
4. New Database panel displayed
5. Entered name of database - pip
6. Clicked "OK"
7. Receieved error dialog with followig message:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'pip'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Could not obtain exclusive lock on database 'model'. Retry the operation later.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 1807)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=1807&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Hi,
I have connected sdf database through SQL server management studio.
I want to execute a simple query as,
CREATE TABLE [dbo].[user]( [user_id] [int] NOT NULL)
While executing the same through Query pane, it gives error as,
<>
Major Error 0x80040E14, Minor Error 26100
> CREATE TABLE [dbo].[user]( [user_id] [int] NOT NULL)
The table name is not valid. [ Token line number (if known) = 1,Token line offset (if known) = 22,Table name = user ]
<>
Any pointers?
Thanks,
Shailesh.
Hello everybody
Had some problems yesterday with a full transaction log. Was able to solve it by following microsofts knowledge base article n° 272318.
However, today I'm trying to create a new DB using the enterprise manager and get this error:
d:databasesHERCULES_1_Data.MDF: Operating system error 112(Es steht nicht genug Speicherplatz auf dem Datenträger zur Verfügung.) encountered.
The free disk space is > 60GB. That's by far enough... I only need 1-2 GB.
Any ideas what's wrong here?
Thanks anyone in advance for some guideance.
Renaud
I have an application which will create a SQL database(using CREATE DATABASE) and the database files are supposed to be placed in c:program filesmyAppdatamyDatabase.mdf
View 11 Replies View RelatedHi Guys,This is my first post and I hope I'm not going to embarrass myself to much.I am currently writing a pseudo install package for SQL Server Express, it is written in VB.Net 2.0.
I have created an *.exe that fires the SQL Server Express install package silently with command line options, once complete the *.exe copies an *.MDF and an *.LDF to the newly created data directory. Once the data has been copied I fire a "CREATE DATABASE FOR ATTACH" using a SQLClient.SQLCommand to attach my DB. I am using Windows Authentication for SQL Server Express.This all works beautifully when the *.exe is being run from a local hard disk - complete success.When I move the *.exe to a CD it fails . SQL Server is installed correctly, the files are copied to the local hard disk in the correct location. I then fire the "CREATE DATABASE" command - its here I get the error.The error details are:Unable to open the physical file "c:....Exchange.LDF". Operating System error 5:"5(error not found)". Cannot create file "c:....Exchnage.ldf" because it already exists. Change the file path or file name, and retry the operation. Could not open new database 'Exchange'. CREATE DATABASE is aborted. File activation failure. The physical file name "c:....Exchange.LDF" may be incorrect.Remember this works perfectly when run from the local hard disk, this only occurs when running from a CD-ROM.Now from the research I have done I believe it may be a permissions error. The setup *.exe is being run from a Administrator account and the SQL Server DB Engine Service Account is System. I'm under the impression that this should provide more than enough permissions.
Thanks for any help you guys may be able to provide...
Matt.
I am using VB with Visual Studio Express. I am new to these tools. I have SQL Server 2005 Express installed on my machine. I think that I have the right version. I am just using Express for taking classes and teaching myself on my machine.
When I follow the examples in the book, I keep getting this error when I go to my ASP.NET configuration and click on the security tab to add myself as a user.
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote) " -- end of erro msg.
I have an apostrophe in my last name. Could that be what is causing it? Is it creating a db based on my name or something? Or do I have the wrong version of SQL Server Express installed.
Thank you for any help. I appreciate it.
--Mark
I searched and found similar questions on this forum, but nothing quite fits my situation.
When I try to run the SQLCMD per the instructions given on the 2nd page of the Guided Tour, the command aborts with the following message.
HResult 0x2, Level 16, State 1Named Pipes Provider: Could not open a connection to SQL Server [2].Sqlcmd: Error: Microsoft SQL Native Client : 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..Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I had to run the command from the command prompt window by manually navigating to sqlcmd's subdirectory to see this message. Using the Run window results in the command window closing before the message can be read. I tried using both my machine name and "localhost." Same result.
What is a local vs. remote connection? How could I perform this via a local connection, assuming that's the problem? Or how can SQL Express be configured to allow the remote connection? Did I do something wrong on the install?
Hi All,
I'm running SQL Server 2002 and trying to create a User Defined Function. However, everytime I try to save the script I get Error 170 Incorrect Syntax near 'FUNCTION'.
This happens if I create the Function from Code or use the Enterprise Manager. I'm logged in with 'sa' privs, so I don't think it's a privilege issue. I'm well confused.
Anyone help?
TIA
William.
Hi
I was asked to import some data from excel into a table within a sqlserver 2000 db the import was complaining about an index so then I deleted the index imported the data succesfilly but I'm now unable to re create the index, please see the error that I'm getting below. Can someone please help.
Thanks
- Unable to create index 'trainingGo'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 32. Most significant primary key is '439'.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Hi.
I get this error when i try to create a relationship in a db diagram (sql 2005)
"'tblActivedir' table saved successfully
'tblClient' table
- Unable to create relationship 'FK_tblClient_tblActivedir1'.
Introducing FOREIGN KEY constraint 'FK_tblClient_tblActivedir1' on table 'tblClient' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Could not create constraint. See previous errors."
What i have is 2 tables.
1 named client
1 named activedir
In the client table the columns i want to bind with activedirtable are FR1 and DC1
I want to bind them in the ID of the activedir table (both, in different fk relationships) so that they get the id of activedir.
Fr1 has an fk relationship with activedir (pk is activedir' id)
and DC1 exactly the same in another fk.
So i want both columns to comunicate with activedir.
If p.e. activedir has 3 elements (a,b,c) when i delete element a then werever FR1 or DC1 have this element(binded to it's id) then the element will also be deleted (id of the element) from both FR1 and DC1
I don't want to set Delete and Update action to none because i want the element changed or deleted from activedir, to do the same on Fr1 or DC1 or both.
Any help?
Thanks.
Hi,
I need to create a new web site in Internet Information Service.
This can be done by opening IIS manager.
In IIS Manager, expand the local computer, right-click the Web Sites folder, point to New, and then click Web Site. The Web Site Creation Wizard appears.
But if i right click the Web Site Folder. only Properties and Refresh option is showing.New option is not shown.
I will appreciate if any one give solution to solve this problem.
I am using Windows XP with SP2.
Thank you
Dear Friends,
I have two different sql servers one two different domains connected by internet. Iam working on Doman-A. Both sql server's are 2005
Domain Name System Name Sql Instance Name Port No
Domain-A SysA(IP:202.187.65.124) SqlA 1215
Domain-B SysB(IP:102.45.68.125) SqlB 1465
Intially I was unable to connect from SysA to SysB through sql management studio. But after giving the connection string as 102.45.68.125SqlB,1465 I was able to connect. Now my main problem is with the replication only. I had configured Publisher and Distrbutor on SysA. I want the subscriber to be SysB. But when I try to configure the subscription in the New Subscription Wizard from SSMS installed on SysA and try to Configure the subscription I get the following error message:
TITLE: New Subscription Wizard
------------------------------
SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'SysBSqlB'. (Replication.Utilities)
Plz help me guys.
Thanking you
Chandra Mohan N
Hi,
Please provide some help regarding the "Interface Defining Error: IID_IDBDataSourceAdmin" error while trying to create a SDF database using Query Analyzer on a Windows CE 5.0 mobile device (Symbol MC3000).
Error: 0x80004005 E_FAIL
Native Error: 28558
Description: SQL Mobile encountered problems when creating database [,,,,]
Param. 0: 0
Param. 1: 0
Param. 2: 0
Param. 3:
Param. 4:
Param. 5:
A list of (related) installed packages:
NETCFv2.wce5.armv4i.cab
sqlce30.dev.ENU.wce5.armv4i.CAB
sqlce30.repl.wce5.armv4i.CAB
sqlce30.wce5.armv4i.CAB
PS.
Basically I have developed a mobile application that programmatically creates the database, the code worked on a similar device (Win CE 50), trying to run the application on a new device resulted in database creation errors. I tried creating a test database manually .. and this is what I got.
Browsing MSDN or searching on the Forum did not help.
~Zarko Gajic
I tried to create a stored procedure but instead of opening up to a new stored procedure it displays an exist stored procedure. I erased the code and typed in my code now i received this error message.
MS SQL-DMO (ODBC SQLState:42000)
Error 2729: Procedure ‘spUpdate_date_time’ group number 1 already exists
in the database. Choose another procedure name
Does anyone know how I can fix this?
Your help is appreciated
I just started having an issue with maintenance tasks. When I click on one of my jobs to modify it I get the following error. Also I am unable to create a new task unless I use the wizard? Could not load file or assembly 'msddsp, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (Microsoft.DataTransformationServices.Design)
Program Location:
at Microsoft.DataTransformationServices.Design.DtsComponentDiagram.CreateDdsView(Control parentControl)
at Microsoft.DataWarehouse.Controls.DdsDiagramHostControl.set_ComponentDiagram(ComponentDiagram value)
at Microsoft.DataTransformationServices.Design.DbMaintSequenceDesigner.get_DbMaintDiagramHost()
[code]....