Guest User

Untitled

a guest
Aug 19th, 2018
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. 1. Open Viev/SQL Server Object Explorer (sql_server_explorer.png)
  2. 2. Click NewQuery
  3. 2.1 Copy TSQL query from "create viperMvcTest from file.sql"
  4. 2.2 Change pathes for yours and run. For example mine(viper - is extracted folder from archive):
  5.  
  6. use master;
  7. go
  8. RESTORE DATABASE [viperMvcTest] FROM DISK = N'C:\Users\Sasha\Desktop\viper\database\viperMvcTest.bak'
  9. WITH MOVE N'VIPER2_PROD' TO N'C:\Users\Sasha\Desktop\viper\ViperMVC\App_Data\viperMvcTest.mdf',
  10. MOVE N'VIPER2_PROD_log' TO N'C:\Users\Sasha\Desktop\viper\ViperMVC\App_Data\viperMvcTest.ldf';
  11. go
  12.  
  13. 2.3 Refresh Sql Server in SQL Server Object Explorer and in database folder viperMvcTest Db apear(sql_server_explorer2.png)
  14.  
  15. 3. Copy TSQL query from "create guest user.sql", change like in example and run
  16.  
  17. USE [master]
  18. GO
  19.  
  20. CREATE LOGIN [sasha] WITH PASSWORD='sasha123', DEFAULT_DATABASE=[viperMvcTest], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
  21. GO
  22.  
  23. 4. Open Web.config and modified line 15
  24. <add name="ViperContext" connectionString="Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=viperMvcTest;User=sasha;Password=sasha123" providerName="System.Data.SqlClient" />
  25. 4. Open Viev/Server Explorer
  26. 4.1 ViperContext -> Modify connection
  27. 4.2 Server Name = (localdb)\MSSQLLocalDB, username = sasha, pass = sasha123(server.png)
  28.  
  29. 5. Run(F5)
Add Comment
Please, Sign In to add comment