Advertisement
Guest User

Untitled

a guest
Nov 14th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. jdbc:sqlserver://localhost\SQLEXPRESS:1433;database=mydb;user=username;password=psw
  2.  
  3. jdbc:sqlserver://localhost;instanceName=SQLEXPRESS;database=mydb;user=username;‌​password=psw'
  4.  
  5. instanceName = SQLEXPRESS;
  6. database = mydb; -- database mydb should exists
  7. user = userName;‌ -- user should exits and have permission to mydb
  8. ​password = userPassword
  9.  
  10. USE [master]
  11. GO
  12. CREATE LOGIN [userName] WITH PASSWORD=N'userPassword',
  13. DEFAULT_DATABASE=[YourDB], CHECK_EXPIRATION=OFF,CHECK_POLICY=OFF
  14.  
  15. GO
  16. USE [YourDB] -- in your case its mydb
  17. GO
  18. CREATE USER [userName] FOR LOGIN [userName] WITH DEFAULT_SCHEMA=[dbo]
  19. GO
  20.  
  21. jdbc:sqlserver://localhost\SQLEXPRESS;database=mydb;user=username;password=psw
  22.  
  23. jdbc:sqlserver://localhost\SQLEXPRESS,1433;database=mydb;user=username;password=psw
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement