[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


sql server 2005

Posted on 2008-11-05
Medium Priority
Last Modified: 2012-05-05
we can log on locally(Server 2003 R2 running SQL 2005) as administrator(Windows) and to sage construct. We cannot logon TO SAGE Construct locally as any other user even if given full admin rights.

See attached error message...........
Question by:purpleoak

Expert Comment

ID: 22887970
Can you confirn this!

1. Since your using SQL Authentication - have u created user 'master' in on the database in sql server?

can you also paste connection string when u got into as a administrater?
LVL 60

Accepted Solution

Kevin Cross earned 2000 total points
ID: 22891421
Having full admin rights to the system doesn't necessarily grant you admin rights in SQL Server.  If you are using SQL Authentication as asked above, then only SQL defined login credentials will be able to login.  If the administrator was used to run the install, that user is usually made the server administrator which is why you can get in with that id.  You can switch SQL Authentication to mixed to include Windows authentication too and then you will have to map the Windows group and/or users that you want to have access to login and specific permissions they should have on database or SQL server itself.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question