Do I need admin rights to import or create new database
-
Good morning everyone.
I am starting to learn SQL. For this purpose I have downloaded SQL Server and SSMS on my office machine. Both are installed successfully. However, when I try to import an excel file with SSMS I am not able to see import feature on my SSMS. I tried checking this GPT and it is saying that I need permission from office IT for the same. Can anyone please help me understanding if GPT assessment is correct. My apologies if my question is violating forum rules.
GPT
"Your SSMS (SQL Server Management Studio) setup is technically complete, but your user account does not have the necessary permissions to fully use it. You cannot create databases or import data because you only have access to system databases, and you don’t have write permissions on any user databases"
-
Hi,
what kind of permission got your account you are working on the sql server?
SysAdmin Role?
Are you able to create a database in the ssms gui?
And are you able to connect to your installed sql server?
I think we need more information to give you some help.
Kind regards,
Andreas
-
OK, so, importing from Excel and creating a database are two very different operations. Let's focus first on the create database question. In SSMS, either, right click on databases, select "New Database" from the context menu, give it a name, and hit OK, or, type in to a T-SQL window, the command, 'CREATE DATABASE mydatabasename'. If those work, you can create a database.
Now, there is every likelihood ChatGPT is giving you some bad info. Have you specified which version of SSMS you're running. If you downloaded recently, I'll bet it's 21. That's a complete rewrite of the tool. Frankly, not everything was moved from the old version of SSMS. For example, if you were planning to use the "Import Data" wizard. That's there in 20, and prior, but not in 21. In 21 that menu choice is grayed out. That may be what you're seeing. It has absolutely nothing to do with whether or not you have permissions to create a database. That's ChatGPT hallucinating.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Hi,
I am extreamally sorry for late reply. Though I was regularly online on the forum I missed to check the replies to my own thread.
I did not see any notificitions for the replies however I should have checked by clicking on my own post. Kindly give me some time to revert.
- Grant Fritchey wrote:
I'll bet it's 21. .
Hi Grant, thanks a lot for the help.
It is 21.4.8.
I guess I am not able to create a new database. I tried to follow the steps you have mentioned but I am getting an error.
Have a nice day ahead. 🙂
- andreas.kreuzberg wrote:
I think we need more information to give you some help.
Hi Andreas, thanks a lot for the help. My apologoies for not providing enough information. To be honest, I am not aware yet what are the factors I should have mentioned in my original post. I have SQL Server 2022 installed on my machine.
I have SSMS 21 installed. I am not able to create new database in SSMS GUI. I guess I am able to connect to SQL server, I provide localhost as Server Name in Connect (Previw) window and clicked OK. This seems to be working. I get this window as soon as I open SSMS.
Have a nice day ahead. 🙂
-
Hm,
did you create the SA login during the sql server installation. If yes, you should know the password.
In the gui, where you can connect to the sql server wihtin the ssms, you can change the Authentication method from "windows authentication" to sql server authentication.
Here you are able to use the sa account with your password.
Please let us know, if you can login with your sa account.
Kind regard
Andreas
-
Hi Andreas, thanks for the help. I might be wrong too, but I have selected windows authentication while doing the installation.
I tried changing this to sql server authentication but not able to proceed. Reason is, I have not created any credentials for sql server authentication while doing the installation. Is there a way where I can do it or check in SQL server.
Have a nice day ahead.
- Grant Fritchey wrote:
For example, if you were planning to use the "Import Data" wizard. That's there in 20, and prior, but not in 21
What on Earth are they thinking?
Lordy...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Connect in SSMS and then select the security tab. Then expand logins, you should see something like:
Is your Windows login listed? For me, Aristotle\Steve is my local login. If I right click and click properties, I can then choose Server Roles. What do you see? Here's mine:
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply