Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-04-2019, 11:22 PM   #1
Zedster
Newly Registered User
 
Join Date: Jul 2019
Location: UK Warwickshire
Posts: 47
Thanks: 22
Thanked 0 Times in 0 Posts
Zedster is on a distinguished road
SQL Server Installation Issues

I have just received a new laptop from our IT department which they always preconfigure with requested software.

The laptop was configured with SQL Server Express 2016/7? and SSMS V18.2.

The SQL Express is for me to "play" with and I use SSMS to connect to SQL Express and the company SQL Server which is 2016.

I have a couple of problems:
  • Whilst they have installed SSE I am not the DBA and have not been given permissions to create databases (so not much use really)
  • SSMS V18.2 no longer has a debugger

I would like to remove SSMS V18.2 and replace it with SSMS V17 to get debugger back.

I would also like to install SQL Server Developer Edition 2017 myself a) to learn, b) so I can configure it to grant me permissions to create databases. At this point SSE will be redundant.

Questions:
  • Can SQL Server developer 2017 co-exist with SQL Server Express?
  • What version of SSMS does SSD 2017 come with?
  • Would uninstalling SSE 2017 get rid of SSMS V18.2?

Zedster is offline   Reply With Quote
Old 09-05-2019, 12:29 AM   #2
sonic8
AWF VIP
 
Join Date: Oct 2015
Posts: 267
Thanks: 41
Thanked 76 Times in 73 Posts
sonic8 is on a distinguished road
Re: SQL Server Installation Issues

Quote:
Originally Posted by Zedster View Post
I would like to remove SSMS V18.2 and replace it with SSMS V17 to get debugger back.

I would also like to install SQL Server Developer Edition 2017 myself a) to learn, b) so I can configure it to grant me permissions to create databases. At this point SSE will be redundant.
You need admin permissions to do that. - If you had them, you would be able to create databases in the existing installation.

Quote:
Originally Posted by Zedster View Post
Questions:
  • Can SQL Server developer 2017 co-exist with SQL Server Express?
Yes.

Quote:
Originally Posted by Zedster View Post
  • Would uninstalling SSE 2017 get rid of SSMS V18.2?
Pay attention to what you are uninstalling. The server and the client tools may be different components of the setup or might be different installations altogether.
__________________
New article:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonic8 is offline   Reply With Quote
Old 09-05-2019, 01:14 AM   #3
Zedster
Newly Registered User
 
Join Date: Jul 2019
Location: UK Warwickshire
Posts: 47
Thanks: 22
Thanked 0 Times in 0 Posts
Zedster is on a distinguished road
Re: SQL Server Installation Issues

Quote:
Originally Posted by sonic8 View Post
You need admin permissions to do that. - If you had them, you would be able to create databases in the existing installation.
I have admin permissions on the laptop. I am trying to create the database and data in the instance of SQL Server Express that accompanies the book T-SQL Fundamentals found here: http://tsql.solidq.com/books/tf3/

The first few lines of code are:

Code:
-- 1. Connect to your SQL Server instance, master database

-- 2. Run the following code to create an empty database called TSQLV4
USE master;

-- Drop database
IF DB_ID(N'TSQLV4') IS NOT NULL DROP DATABASE TSQLV4;

-- If database could not be created due to open connections, abort
IF @@ERROR = 3702 
   RAISERROR(N'Database cannot be dropped because there are still open connections.', 127, 127) WITH NOWAIT, LOG;

-- Create database
CREATE DATABASE TSQLV4;
GO

USE TSQLV4;
GO
I get the following:

Msg 262, Level 14, State 1, Line 38
CREATE DATABASE permission denied in database 'master'.
Msg 911, Level 16, State 1, Line 41
Database 'TSQLV4' does not exist. Make sure that the name is entered correctly.
Msg 15247, Level 16, State 1, Line 83
User does not have permission to perform this action.
Msg 2759, Level 16, State 0, Line 83
CREATE SCHEMA failed due to previous errors.
Msg 15247, Level 16, State 1, Line 85

Zedster is offline   Reply With Quote
Old 09-05-2019, 05:37 AM   #4
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,203
Thanks: 28
Thanked 276 Times in 263 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: SQL Server Installation Issues

Some employees like myself are given permissions to manipulate there own databases via SSMS. My permissions do not allow for creating new databases within the master. So either IT creates new space then allows me access to it, or I have to keep adding to the database I currently use.

Since the databases I currently use are related in scope to my job I choose to remain in the original (container) space.

After 10 years of doing this I have not encountered any space limitations, just clutter.
AccessBlaster is offline   Reply With Quote
Old 09-05-2019, 08:14 AM   #5
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,432
Thanks: 165
Thanked 1,736 Times in 1,706 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: SQL Server Installation Issues

It looks like it's telling you you can't create a database in the system Master database - which you can't. I think that is protected from containing other databases with good reason.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Office 2007 Installation and Clipboard Issues jdivito General 4 06-24-2010 12:04 PM
I want sql server 2000 for installation. aligahk06 SQL Server 2 05-04-2010 04:06 PM
client server installation prodigy SQL Server 8 01-09-2006 06:53 AM
Performance issues when changed server IanW General 1 11-06-2002 05:14 AM
Project- Server connection issues VBAhole22 General 0 10-09-2002 01:14 PM




All times are GMT -8. The time now is 04:19 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World