Comments (4)
This error usually means that the c:\sql\dbfiles\ directory does not exist. Verify that it does and try running the create all script again. If you are still getting an error - please send me the complete output from the command prompt session so that I can further assist you.
Thanks - Todd
from ds3.
Hi Todd,
Thanks for getting back to me so quickly! The directory does exist. Here is the output after running the script again:
C:\ds3-master\ds3\sqlserverds3>osql -S -UTMTest -i sqlserverds3_create_all_10MB.sql
Password:
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> Msg 5133, Level 16, State 1, Server OFVWSQL01, Line 2
Directory lookup for the file "C:\sql\dbfiles\ds.mdf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 1802, Level 16, State 1, Server OFVWSQL01, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 4
Invalid filegroup 'DS_CUST_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_CUST_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_MEMBER_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 3
Invalid filegroup 'DS_ORDERS_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_ORDERS_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_MISC_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_REVIEW_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_REVIEW_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_MISC_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_MISC_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> Msg 1088, Level 16, State 11, Server OFVWSQL01, Line 2
Cannot find the object "CATEGORIES" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> Msg 1921, Level 16, State 1, Server OFVWSQL01, Line 2
Invalid filegroup 'DS_MISC_FG' specified.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> Msg 8197, Level 16, State 4, Server OFVWSQL01, Procedure RESTOCK, Line 3
The object 'INVENTORY' does not exist or is invalid for this operation.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 3
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> Msg 5011, Level 14, State 5, Server OFVWSQL01, Line 1
User does not have permission to alter database 'DS3', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Server OFVWSQL01, Line 1
ALTER DATABASE statement failed.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUSTOMERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUSTOMERS'.
1> 2> 3> 4> 5> 1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERS'.
1> 2> 3> 4> 5> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 4
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'ORDERLINES'.
1> 2> 3> 4> 5> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 4
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'CUST_HIST'.
1> 2> 3> 4> 5> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 4
Invalid object name 'PRODUCTS'.
1> 2> 3> 4> 5> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 4
Invalid object name 'INVENTORY'.
1> 2> 3> 4> 5> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 4
Invalid object name 'MEMBERSHIP'.
1> 2> 3> 4> 5> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 4
Invalid object name 'REVIEWS'.
1> 2> Msg 208, Level 16, State 82, Server OFVWSQL01, Line 1
Invalid object name 'REVIEWS_HELPFULNESS'.
1> 2> 3> Msg 5011, Level 14, State 5, Server OFVWSQL01, Line 2
User does not have permission to alter database 'DS3', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Server OFVWSQL01, Line 2
ALTER DATABASE statement failed.
1> 2> 3> 4> 5> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "CATEGORIES" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "CUSTOMERS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "CUSTOMERS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "CUST_HIST" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "CUST_HIST" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "CUST_HIST" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "ORDERS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "ORDERS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "ORDERLINES" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "ORDERLINES" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "INVENTORY" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> 9> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> Msg 15247, Level 16, State 1, Server OFVWSQL01, Procedure sp_fulltext_database, Line 27
User does not have permission to perform this action.
Msg 15247, Level 16, State 1, Server OFVWSQL01, Procedure sp_fulltext_catalog, Line 20
User does not have permission to perform this action.
Msg 9966, Level 16, State 1, Server OFVWSQL01, Procedure sp_fulltext_table, Line 18
Cannot use full-text search in master, tempdb, or model database.
Msg 9966, Level 16, State 1, Server OFVWSQL01, Procedure sp_fulltext_column, Line 19
Cannot use full-text search in master, tempdb, or model database.
Msg 9966, Level 16, State 1, Server OFVWSQL01, Procedure sp_fulltext_column, Line 19
Cannot use full-text search in master, tempdb, or model database.
Msg 9966, Level 16, State 1, Server OFVWSQL01, Procedure sp_fulltext_table, Line 18
Cannot use full-text search in master, tempdb, or model database.
Msg 15247, Level 16, State 1, Server OFVWSQL01, Procedure sp_fulltext_catalog, Line 20
User does not have permission to perform this action.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "INVENTORY" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "MEMBERSHIP" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "MEMBERSHIP" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS_HELPFULNESS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> Msg 4902, Level 16, State 1, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS_HELPFULNESS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS_HELPFULNESS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS_HELPFULNESS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "REORDER" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 2
Cannot find the object "dbo.REVIEWS_HELPFULNESS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 4
Cannot find the object "CUSTOMERS" because it does not exist or you do not have permissions.
1> 2> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 1
Cannot find the object "CUSTOMERS" because it does not exist or you do not have permissions.
1> 2> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 1
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 1
Cannot find the object "PRODUCTS" because it does not exist or you do not have permissions.
1> 2> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 1
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 1
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 1
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 1
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> Msg 1088, Level 16, State 12, Server OFVWSQL01, Line 1
Cannot find the object "REVIEWS" because it does not exist or you do not have permissions.
1> 2> 3> 4> 5> 6> 7> 8> 9> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 6
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure NEW_CUSTOMER, Line 2
There is already an object named 'NEW_CUSTOMER' in the database.
1> 2> 3> 4> 5> 6> 7> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure NEW_MEMBER, Line 2
There is already an object named 'NEW_MEMBER' in the database.
1> 2> 3> 4> 5> 6> 7> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure NEW_PROD_REVIEW, Line 2
There is already an object named 'NEW_PROD_REVIEW' in the database.
1> 2> 3> 4> 5> 6> 7> 8> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 5
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure NEW_REVIEW_HELPFULNESS, Line 2
There is already an object named 'NEW_REVIEW_HELPFULNESS' in the database.
1> 2> 3> 4> 5> 6> 7> 8> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 5
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure LOGIN, Line 2
There is already an object named 'LOGIN' in the database.
1> 2> 3> 4> 5> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure BROWSE_BY_CATEGORY, Line 2
There is already an object named 'BROWSE_BY_CATEGORY' in the database.
1> 2> 3> 4> 5> 6> 7> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure BROWSE_BY_CATEGORY_FOR_MEMBERTYPE, Line 2
There is already an object named 'BROWSE_BY_CATEGORY_FOR_MEMBERTYPE' in the database.
1> 2> 3> 4> 5> 6> 7> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure GET_PROD_REVIEWS, Line 2
There is already an object named 'GET_PROD_REVIEWS' in the database.
1> 2> 3> 4> 5> 6> 7> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure GET_PROD_REVIEWS_BY_STARS, Line 2
There is already an object named 'GET_PROD_REVIEWS_BY_STARS' in the database.
1> 2> 3> 4> 5> 6> 7> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure GET_PROD_REVIEWS_BY_DATE, Line 2
There is already an object named 'GET_PROD_REVIEWS_BY_DATE' in the database.
1> 2> 3> 4> 5> 6> 7> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure GET_PROD_REVIEWS_BY_ACTOR, Line 2
There is already an object named 'GET_PROD_REVIEWS_BY_ACTOR' in the database.
1> 2> 3> 4> 5> 6> 7> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 4
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure GET_PROD_REVIEWS_BY_TITLE, Line 2
There is already an object named 'GET_PROD_REVIEWS_BY_TITLE' in the database.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 7
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure BROWSE_BY_ACTOR, Line 2
There is already an object named 'BROWSE_BY_ACTOR' in the database.
1> 2> 3> 4> 5> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure BROWSE_BY_TITLE, Line 2
There is already an object named 'BROWSE_BY_TITLE' in the database.
1> 2> 3> 4> 5> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 2
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143> Msg 2714, Level 16, State 3, Server OFVWSQL01, Procedure PURCHASE, Line 2
There is already an object named 'PURCHASE' in the database.
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> Msg 911, Level 16, State 1, Server OFVWSQL01, Line 12
Database 'DS3' does not exist. Make sure that the name is entered correctly.
1>
from ds3.
Two suggestions:
The script expects to be run locally on the db host. I'm guessing that you are running it remotely because you specify the IP address of the host.
The other possibility is that the user TMTest does not have access rights to the c:\sql\dbfiles directory or some other needed role in SQL Server.
Thanks,
Todd
from ds3.
Hi Todd,
Great news, suggestion 1 was correct!
osql wasn't working without specifying the ip address. I thought it was strange but didn't think too much of it. I thought that I was specifying the ip of the local machine but it turns out it was actually a remote machine.
For anyone else who encounters the same issue, osql wasn't working locally because mssql needed a restart. You can do this by going to SQL Configuration Manager -> SQL Server Services and then restart (or start if they are not already running) SQL Server and SQL Server Browser processes.
Thanks for making such a great application and for helping me out with this Todd, much appreciated!
from ds3.
Related Issues (9)
- Create Login Script references both ds2user and ds3user HOT 1
- Server 2016 Nano support HOT 2
- Incorrect format in parameter (Generated ConfigFile) HOT 3
- Errors thrown when requesting database target size over 1TB HOT 5
- Error accessing server machine HOT 4
- Connection issues to windows server HOT 1
- Issue with Data Load HOT 17
- Running on multiple SQL servers HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ds3.