Avatar of DuNuNuBatman
DuNuNuBatman
 asked on

aspnet_regsql question

I am running sql express that came with my visual studio program. Anyway, I am trying to run aspnet_regsql on my machine but I keep getting an error.

Start adding the following features:
Membership
Profile
RoleManager

.
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 5133 and the SqlException message is: Directory lookup for the file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\C:\Users\Josh\Documents\Visual Studio Codename Orcas\Projects\DTC\Website\App_Data\DtcDatabase.mdf.mdf" failed with the operating system error 123(The filename, directory name, or volume label syntax is incorrect.).
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Creating the C:\Users\Josh\Documents\Visual Studio Codename Orcas\Projects\DTC\Website\App_Data\DtcDatabase.mdf database...
SQL Server: localhost\SQLExpress
Database: [C:\Users\Josh\Documents\Visual Studio Codename Orcas\Projects\DTC\Website\App_Data\DtcDatabase.mdf]
SQL file loaded:
InstallCommon.sql

Commands failed:

DECLARE @dbname nvarchar(128)
DECLARE @dboptions nvarchar(1024)

SET @dboptions = N'/**/'
SET @dbname = N'C:\Users\Josh\Documents\Visual Studio Codename Orcas\Projects\DTC\Website\App_Data\DtcDatabase.mdf'

IF (NOT EXISTS (SELECT name
                FROM master.dbo.sysdatabases
                WHERE name = @dbname))
BEGIN
  PRINT 'Creating the ' + @dbname + ' database...'
  DECLARE @cmd nvarchar(500)
  SET @cmd = 'CREATE DATABASE [' + @dbname + '] ' + @dboptions
  EXEC(@cmd)
END

SQL Exception:
System.Data.SqlClient.SqlException: Directory lookup for the file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\C:\Users\Josh\Documents\Visual Studio Codename Orcas\Projects\DTC\Website\App_Data\DtcDatabase.mdf.mdf" failed with the operating system error 123(The filename, directory name, or volume label syntax is incorrect.).
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Creating the C:\Users\Josh\Documents\Visual Studio Codename Orcas\Projects\DTC\Website\App_Data\DtcDatabase.mdf database...
   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 System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)

ASP.NETC#.NET Programming

Avatar of undefined
Last Comment
DuNuNuBatman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Fareed Ali Khan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
DuNuNuBatman

ASKER
I'm still getting the same error.
Fareed Ali Khan

Please give the statement that you run with complete file name
DuNuNuBatman

ASKER
aspnet_regsql -A mrp -C "Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True" -d "C:\Users\Josh\Documents\Visual Studio Codename Orcas\Projects\DTC\Website\App_Data\DtcDatabase.mdf"
Your help has saved me hundreds of hours of internet surfing.
fblack61
Fareed Ali Khan

DuNuNuBatman

ASKER
alright, I figured it out. When I tried to attach the database using sql server management studio, I noticed I couldn't browse past the C:\Users\Josh directory. I then tried to manually put in the path to the mdf file and got the same error. So I changed the permissions to my users directory and sub dirs and that fixed it. So I was just having some weird permissions issues.
Anyway, it ran, problem solved. Thanks for the help!