Attach Database is disabled in Microsoft SQL Server 2012 Management Studio The 2019 Stack...
What is the meaning of Triage in Cybersec world?
How technical should a Scrum Master be to effectively remove impediments?
Why hard-Brexiteers don't insist on a hard border to prevent illegal immigration after Brexit?
"as much details as you can remember"
Origin of "cooter" meaning "vagina"
Where to refill my bottle in India?
Is there a symbol for a right arrow with a square in the middle?
Geography at the pixel level
Write faster on AT24C32
Why is the maximum length of OpenWrt’s root password 8 characters?
For what reasons would an animal species NOT cross a *horizontal* land bridge?
What is the closest word meaning "respect for time / mindful"
Resizing object distorts it (Illustrator CC 2018)
Am I thawing this London Broil safely?
What does ひと匙 mean in this manga and has it been used colloquially?
Identify boardgame from Big movie
Scaling a graph of a circle and the standard parabola in TikZ
Multiply Two Integer Polynomials
Did Section 31 appear in Star Trek: The Next Generation?
Are children permitted to help build the Beis Hamikdash?
Is a "Democratic" Feudal System Possible?
How are circuits which use complex ICs normally simulated?
One word riddle: Vowel in the middle
FPGA - DIY Programming
Attach Database is disabled in Microsoft SQL Server 2012 Management Studio
The 2019 Stack Overflow Developer Survey Results Are InSQL Server 2008: The login is from an untrusted domain and cannot be used with Windows authenticationAccessing a SQL Server Denali CTP1 database with Management Studio 2012 SP1 ExpressSQL Server Windows authentication: VMs versus othersSQL Server Management studio slow connection or timeout when using Windows AuthenticationOpening a stored procedure file multiple times in sql server management studioUnable to attach database to Amazon RDS using SQL Server Management Studio 2016Attached database to SQL Server 2016 and now won't work in SQL Server 2014Cannot re-attach SqlExpress database to the same database server after detaching?creating server with Microsoft Server Management StudioSQL Server Management Studio - Debugger buttons greyed
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have buy from Godadday hosting and domain, after that I have create database in godaddy and the connect to this db using my authentication.
I have .mdf, .ldf that need to attach to the connected server, I am going to Object Explorer -> Database -> Attach -> Attach database screen is opened but everything inside is disabled.
What can I do to enable attaching my local DB to the server DB?
Thank you so much for helping.
I am using SQL Server 2012 Management Studio
sql-server sql-server-2012
edited Jul 18 '15 at 6:33
marc_s
7,12853849
asked Jul 14 '15 at 13:51
user2274204user2274204
61
bumped to the homepage by Community♦ 17 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have buy from Godadday hosting and domain, after that I have create database in godaddy and the connect to this db using my authentication.
I have .mdf, .ldf that need to attach to the connected server, I am going to Object Explorer -> Database -> Attach -> Attach database screen is opened but everything inside is disabled.
What can I do to enable attaching my local DB to the server DB?
Thank you so much for helping.
I am using SQL Server 2012 Management Studio
sql-server sql-server-2012
edited Jul 18 '15 at 6:33
marc_s
7,12853849
asked Jul 14 '15 at 13:51
user2274204user2274204
61
bumped to the homepage by Community♦ 17 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
2
Have you asked GoDaddy?
– Aaron Bertrand♦
Jul 14 '15 at 13:57
Have you tried attaching via T-SQL?
– KASQLDBA
Jul 14 '15 at 14:09
add a comment |
I have buy from Godadday hosting and domain, after that I have create database in godaddy and the connect to this db using my authentication.
I have .mdf, .ldf that need to attach to the connected server, I am going to Object Explorer -> Database -> Attach -> Attach database screen is opened but everything inside is disabled.
What can I do to enable attaching my local DB to the server DB?
Thank you so much for helping.
I am using SQL Server 2012 Management Studio
sql-server sql-server-2012
edited Jul 18 '15 at 6:33
marc_s
7,12853849
asked Jul 14 '15 at 13:51
user2274204user2274204
61
I have buy from Godadday hosting and domain, after that I have create database in godaddy and the connect to this db using my authentication.
I have .mdf, .ldf that need to attach to the connected server, I am going to Object Explorer -> Database -> Attach -> Attach database screen is opened but everything inside is disabled.
What can I do to enable attaching my local DB to the server DB?
Thank you so much for helping.
I am using SQL Server 2012 Management Studio
sql-server sql-server-2012
sql-server sql-server-2012
edited Jul 18 '15 at 6:33
marc_s
7,12853849
asked Jul 14 '15 at 13:51
user2274204user2274204
61
edited Jul 18 '15 at 6:33
marc_s
7,12853849
asked Jul 14 '15 at 13:51
user2274204user2274204
61
edited Jul 18 '15 at 6:33
marc_s
7,12853849
edited Jul 18 '15 at 6:33
marc_s
7,12853849
edited Jul 18 '15 at 6:33
marc_s
7,12853849
7,12853849
asked Jul 14 '15 at 13:51
user2274204user2274204
61
asked Jul 14 '15 at 13:51
user2274204user2274204
61
asked Jul 14 '15 at 13:51
user2274204user2274204
61
61
bumped to the homepage by Community♦ 17 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 17 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
2
Have you asked GoDaddy?
– Aaron Bertrand♦
Jul 14 '15 at 13:57
Have you tried attaching via T-SQL?
– KASQLDBA
Jul 14 '15 at 14:09
add a comment |
2
Have you asked GoDaddy?
– Aaron Bertrand♦
Jul 14 '15 at 13:57
Have you tried attaching via T-SQL?
– KASQLDBA
Jul 14 '15 at 14:09
2
2
Have you asked GoDaddy?
– Aaron Bertrand♦
Jul 14 '15 at 13:57
Have you asked GoDaddy?
– Aaron Bertrand♦
Jul 14 '15 at 13:57
Have you tried attaching via T-SQL?
– KASQLDBA
Jul 14 '15 at 14:09
Have you tried attaching via T-SQL?
– KASQLDBA
Jul 14 '15 at 14:09
add a comment |
1 Answer
1
active
oldest
votes
If you need help attaching via T-SQL, if you see the SCRIPT button on the image you attached, you will be able to output the SCRIPT syntax to attach via 'T-SQL'
Just fill it in with the required information like target path to MDF file etc.. Give that a shot and see what you can come up with.
Also make sure you are on the same version of SSMS as the database to help prevent issues.
Also, when you connect to the DB instance, make sure you are using a Administrative account, it might be different then your current log-in or Windows Auth account.
answered Jul 14 '15 at 15:39
HectorHector
8841620
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f106890%2fattach-database-is-disabled-in-microsoft-sql-server-2012-management-studio%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you need help attaching via T-SQL, if you see the SCRIPT button on the image you attached, you will be able to output the SCRIPT syntax to attach via 'T-SQL'
Just fill it in with the required information like target path to MDF file etc.. Give that a shot and see what you can come up with.
Also make sure you are on the same version of SSMS as the database to help prevent issues.
Also, when you connect to the DB instance, make sure you are using a Administrative account, it might be different then your current log-in or Windows Auth account.
answered Jul 14 '15 at 15:39
HectorHector
8841620
add a comment |
If you need help attaching via T-SQL, if you see the SCRIPT button on the image you attached, you will be able to output the SCRIPT syntax to attach via 'T-SQL'
Just fill it in with the required information like target path to MDF file etc.. Give that a shot and see what you can come up with.
Also make sure you are on the same version of SSMS as the database to help prevent issues.
Also, when you connect to the DB instance, make sure you are using a Administrative account, it might be different then your current log-in or Windows Auth account.
answered Jul 14 '15 at 15:39
HectorHector
8841620
add a comment |
If you need help attaching via T-SQL, if you see the SCRIPT button on the image you attached, you will be able to output the SCRIPT syntax to attach via 'T-SQL'
Just fill it in with the required information like target path to MDF file etc.. Give that a shot and see what you can come up with.
Also make sure you are on the same version of SSMS as the database to help prevent issues.
Also, when you connect to the DB instance, make sure you are using a Administrative account, it might be different then your current log-in or Windows Auth account.
answered Jul 14 '15 at 15:39
HectorHector
8841620
If you need help attaching via T-SQL, if you see the SCRIPT button on the image you attached, you will be able to output the SCRIPT syntax to attach via 'T-SQL'
Just fill it in with the required information like target path to MDF file etc.. Give that a shot and see what you can come up with.
Also make sure you are on the same version of SSMS as the database to help prevent issues.
Also, when you connect to the DB instance, make sure you are using a Administrative account, it might be different then your current log-in or Windows Auth account.
answered Jul 14 '15 at 15:39
HectorHector
8841620
answered Jul 14 '15 at 15:39
HectorHector
8841620
answered Jul 14 '15 at 15:39
HectorHector
8841620
answered Jul 14 '15 at 15:39
HectorHector
8841620
8841620
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f106890%2fattach-database-is-disabled-in-microsoft-sql-server-2012-management-studio%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Have you asked GoDaddy?
– Aaron Bertrand♦
Jul 14 '15 at 13:57
Have you tried attaching via T-SQL?
– KASQLDBA
Jul 14 '15 at 14:09