The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
2answers
48 views

Deny access to self in SQL Server 2012?

I have a unique request from my boss. I'm the only software developer for my company, so I'm doing everything from the initial design to the database design. I regularly design and maintain the ...
0
votes
1answer
69 views

Attaching catalog with SQL Authentication credentials attaches it as Read-Only

As part of our product's installation process, a database is attached to the server. We use EXEC sp_attach_db in order to attach it to MSSQL. The problem occures when we try to attach it with "SQL ...
2
votes
0answers
230 views

sharepoint mysite authentication

I have created mysite and two other sites as 3 different web applications in my sharepoint server like http://site1.sp.com:45 - site 1 http://site2.sp.com:45 - site 2 http://mysite.sp.com:45 - ...
0
votes
0answers
32 views

Login failed for user 'domain\ServerName'

I have creates an asp.net mvc 4 web app. I have deployed it to my dev server. (different box than my local on same domain). Both the database and the website exists on the same server/box. I am ...
0
votes
0answers
70 views

How do you allow a SQL authenticated user to query an Excel file via a linked server (or through OPENDATASOURCE)?

I have a 3rd party dashboard application that I can only use SQL authenticated logins to connect to the database. I'm trying to create a query within the application that will directly access an excel ...
0
votes
0answers
101 views

How to create users and store them in a database and link them to windows authentication logins

What I want: An intranet application where only people who are logged in can see the application... and an Admin and Member role. 1: I have created an MVC 5.0 web application (for intranet). It ...
0
votes
0answers
82 views

How to handle SQL Server Authentication on Failover Partner

Moving to a new database that has mirroring and failover I need to adjust the connection string. The primary and secondary servers will have different SQL Login passwords. I'd like to setup my ...