Sfrgttk

Is there any relevance to Thor getting his hair cut other than comedic value?

Are small insurances worth it

If nine coins are tossed, what is the probability that the number of heads is even?

What is a term for a function that when called repeatedly, has the same effect as calling once?

chrony vs. systemd-timesyncd – What are the differences and use cases as NTP clients?

How to acknowledge an embarrassing job interview, now that I work directly with the interviewer?

I can't die. Who am I?

How can atoms be electrically neutral when there is a difference in the positions of the charges?

What am I? I am in theaters and computer programs

Where is this triangular-shaped space station from?

Which aircraft had such a luxurious-looking navigator's station?

Borrowing Characters

What to do when being responsible for data protection in your lab, yet advice is ignored?

When was drinking water recognized as crucial in marathon running?

Understanding Kramnik's play in game 1 of Candidates 2018

How to avoid being sexist when trying to employ someone to function in a very sexist environment?

What is better: yes / no radio, or simple checkbox?

How to count occurrences of Friday 13th

How to add multiple differently colored borders around a node?

Why zero tolerance on nudity in space?

Do authors have to be politically correct in article-writing?

What can I substitute for soda pop in a sweet pork recipe?

Auto Insert date into Notepad

How can I be pwned if I'm not registered on that site?

Minimum user rights for connecting MS Sql database remotedly

In which form Microsoft SQL password should be given when creating a user?MS SQL Server 2008R2, “Login failed for user” from time to time, IIS 7 , NET 4.0Schema Change/Update script for Database deployMySQL GRANT requiring additional permissionsset right permission to get connection ip for a user mapped to loginExecute grant for MySQL stored procedure revoked when stored procedure is alteredChanging own user permissions with Oracle SQL not being the DBAScripting execute permissions on stored procedurePrevent Modification of dbo objects while allowing other schemas to be modifiedHow to allow user access to non-owned objects in Postgres?SQL Server: Creating a user database with permissions

2

1

I have followed this tutorial for getting connected to a Microsoft SQL Server. I connect with ping functionality of Glassfish Server and thus I have to give some user rights to be able to even ping the Database.

My problem is that probably my user has not rights to take external connections to the database or even more sad, not any permissions. What kind of user permissions there should be applied before I can connect to my database with my user?

(I suppose there are needed some GRANTS before accessing the database, because making that on Mysql needed quite many of them. Now the actual problem is I could not apply the same queries here 'cause the SQL scripts are incombatible)

sql-server permissions

share|improve this question

edited Aug 5 '14 at 13:46

Colin 't Hart

6,58682534

asked Aug 5 '11 at 13:33

micomico

3462617

add a comment | 

2

1

I have followed this tutorial for getting connected to a Microsoft SQL Server. I connect with ping functionality of Glassfish Server and thus I have to give some user rights to be able to even ping the Database.

My problem is that probably my user has not rights to take external connections to the database or even more sad, not any permissions. What kind of user permissions there should be applied before I can connect to my database with my user?

(I suppose there are needed some GRANTS before accessing the database, because making that on Mysql needed quite many of them. Now the actual problem is I could not apply the same queries here 'cause the SQL scripts are incombatible)

sql-server permissions

share|improve this question

edited Aug 5 '14 at 13:46

Colin 't Hart

6,58682534

asked Aug 5 '11 at 13:33

micomico

3462617

add a comment | 

I have followed this tutorial for getting connected to a Microsoft SQL Server. I connect with ping functionality of Glassfish Server and thus I have to give some user rights to be able to even ping the Database.

My problem is that probably my user has not rights to take external connections to the database or even more sad, not any permissions. What kind of user permissions there should be applied before I can connect to my database with my user?

(I suppose there are needed some GRANTS before accessing the database, because making that on Mysql needed quite many of them. Now the actual problem is I could not apply the same queries here 'cause the SQL scripts are incombatible)

sql-server permissions

share|improve this question

edited Aug 5 '14 at 13:46

Colin 't Hart

6,58682534

asked Aug 5 '11 at 13:33

micomico

3462617

share|improve this question

edited Aug 5 '14 at 13:46

Colin 't Hart

6,58682534

asked Aug 5 '11 at 13:33

micomico

3462617

share|improve this question

edited Aug 5 '14 at 13:46

Colin 't Hart

6,58682534

asked Aug 5 '11 at 13:33

micomico

3462617

edited Aug 5 '14 at 13:46

Colin 't Hart

6,58682534

edited Aug 5 '14 at 13:46

Colin 't Hart

6,58682534

asked Aug 5 '11 at 13:33

micomico

3462617

asked Aug 5 '11 at 13:33

micomico

3462617

2 Answers
2

active

oldest

votes

6

Check for "CONNECT" rights

SELECT SUSER_NAME(grantee_principal_id), * 

FROM sys.server_permissions WHERE type = 'COSQ'

GO

USE MYDB

GO

SELECT USER_NAME(grantee_principal_id), * 

FROM sys.database_permissions WHERE type = 'CO'

To fix as needed

USE master

GO

GRANT CONNECT SQL TO myLogin

GO

USE MYDB

GO

GRANT CONNECT TO MyUser

GO

share|improve this answer

answered Aug 5 '11 at 13:41

gbngbn

63.9k7138215

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I added CONNECT on a graphical tool (I feel more comfortable with it) and I was able to connect the Database. Thanks.
  
  – mico
  Aug 8 '11 at 8:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  To be able to connect from another machine I had to give Firewall pass to sqlservr.exe file through the firewall as well as port 1433.
  
  – mico
  Aug 8 '11 at 11:18
  

  
  
  
  

add a comment | 

0

em_scheduler:1366289344]: em_init:version=1.7.0 -- 1.7.4.2,system_path=/storage/sdcard0/TNTGameBox/Download/

share|improve this answer

answered 13 mins ago

user11151057user11151057

1

New contributor

user11151057 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f4380%2fminimum-user-rights-for-connecting-ms-sql-database-remotedly%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

6

Check for "CONNECT" rights

SELECT SUSER_NAME(grantee_principal_id), * 

FROM sys.server_permissions WHERE type = 'COSQ'

GO

USE MYDB

GO

SELECT USER_NAME(grantee_principal_id), * 

FROM sys.database_permissions WHERE type = 'CO'

To fix as needed

USE master

GO

GRANT CONNECT SQL TO myLogin

GO

USE MYDB

GO

GRANT CONNECT TO MyUser

GO

share|improve this answer

answered Aug 5 '11 at 13:41

gbngbn

63.9k7138215

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I added CONNECT on a graphical tool (I feel more comfortable with it) and I was able to connect the Database. Thanks.
  
  – mico
  Aug 8 '11 at 8:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  To be able to connect from another machine I had to give Firewall pass to sqlservr.exe file through the firewall as well as port 1433.
  
  – mico
  Aug 8 '11 at 11:18
  

  
  
  
  

add a comment | 

6

Check for "CONNECT" rights

SELECT SUSER_NAME(grantee_principal_id), * 

FROM sys.server_permissions WHERE type = 'COSQ'

GO

USE MYDB

GO

SELECT USER_NAME(grantee_principal_id), * 

FROM sys.database_permissions WHERE type = 'CO'

To fix as needed

USE master

GO

GRANT CONNECT SQL TO myLogin

GO

USE MYDB

GO

GRANT CONNECT TO MyUser

GO

share|improve this answer

answered Aug 5 '11 at 13:41

gbngbn

63.9k7138215

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I added CONNECT on a graphical tool (I feel more comfortable with it) and I was able to connect the Database. Thanks.
  
  – mico
  Aug 8 '11 at 8:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  To be able to connect from another machine I had to give Firewall pass to sqlservr.exe file through the firewall as well as port 1433.
  
  – mico
  Aug 8 '11 at 11:18
  

  
  
  
  

add a comment | 

Check for "CONNECT" rights

SELECT SUSER_NAME(grantee_principal_id), * 

FROM sys.server_permissions WHERE type = 'COSQ'

GO

USE MYDB

GO

SELECT USER_NAME(grantee_principal_id), * 

FROM sys.database_permissions WHERE type = 'CO'

To fix as needed

USE master

GO

GRANT CONNECT SQL TO myLogin

GO

USE MYDB

GO

GRANT CONNECT TO MyUser

GO

share|improve this answer

answered Aug 5 '11 at 13:41

gbngbn

63.9k7138215

SELECT SUSER_NAME(grantee_principal_id), * 

FROM sys.server_permissions WHERE type = 'COSQ'

GO

USE MYDB

GO

SELECT USER_NAME(grantee_principal_id), * 

FROM sys.database_permissions WHERE type = 'CO'

USE master

GO

GRANT CONNECT SQL TO myLogin

GO

USE MYDB

GO

GRANT CONNECT TO MyUser

GO

share|improve this answer

answered Aug 5 '11 at 13:41

gbngbn

63.9k7138215

answered Aug 5 '11 at 13:41

gbngbn

63.9k7138215

answered Aug 5 '11 at 13:41

gbngbn

63.9k7138215

0

em_scheduler:1366289344]: em_init:version=1.7.0 -- 1.7.4.2,system_path=/storage/sdcard0/TNTGameBox/Download/

share|improve this answer

answered 13 mins ago

user11151057user11151057

1

New contributor

user11151057 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

em_scheduler:1366289344]: em_init:version=1.7.0 -- 1.7.4.2,system_path=/storage/sdcard0/TNTGameBox/Download/

share|improve this answer

answered 13 mins ago

user11151057user11151057

1

New contributor

user11151057 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

em_scheduler:1366289344]: em_init:version=1.7.0 -- 1.7.4.2,system_path=/storage/sdcard0/TNTGameBox/Download/

share|improve this answer

answered 13 mins ago

user11151057user11151057

1

New contributor

user11151057 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this answer

answered 13 mins ago

user11151057user11151057

1

New contributor

user11151057 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 13 mins ago

user11151057user11151057

1

New contributor

user11151057 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 13 mins ago

user11151057user11151057

1