October 6, 2010 at 11:45 am
Brandie Tarvin (10/6/2010)
Stefan Krzywicki (10/6/2010)
Brandie Tarvin (10/6/2010)
Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.Really? I haven't had any problems with it. What's your issue?
EDIT: Sorry. Thought you were going the opposite direction. From Access to SQL. So, why not just give him a front end .mdb with linked tables?
Heh, no. That's the good way. : -)
Permissions and data security mostly. After I have this working, I'm going to suggest we get him SQL Server Express installed on an isolated server that he can access and load it there. Then we can either give him the front-end mdb or a linked excel workbook or even the SQL Server Express version of SSMS.
Okay, but you can still do this. I do it all the time.
Guy has a domain login, right? On SQL Server, grant db_datareader to only the necessary columns on the necessary tables. Then create Access front end .mdb that links to those tables. I promise, he can't see more than what you let him see. And since he doesn't have SQL Server client tools, he can't get access to the data via SSMS (big assumption I'm making here).
EDIT: Doh, forgot to mention the use of a File System ODBC for the Access db to connect to SQL Server.
The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems and I don't want yet another person hitting the main machine. I'd drop him on Dev, but I don't want to hear it when Dev goes down as it should from time to time.
I appreciate the permissions advice as I don't normally get to play with those and the clarification of what I'd do is very helpful.
One other problem of doing it the way you suggest is convinving the other business people currently hitting the database that his additional access wouldn't cause them problems.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 6, 2010 at 11:50 am
Stefan Krzywicki (10/6/2010)
Brandie Tarvin (10/6/2010)
Stefan Krzywicki (10/6/2010)
Brandie Tarvin (10/6/2010)
Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.Really? I haven't had any problems with it. What's your issue?
EDIT: Sorry. Thought you were going the opposite direction. From Access to SQL. So, why not just give him a front end .mdb with linked tables?
Heh, no. That's the good way. : -)
Permissions and data security mostly. After I have this working, I'm going to suggest we get him SQL Server Express installed on an isolated server that he can access and load it there. Then we can either give him the front-end mdb or a linked excel workbook or even the SQL Server Express version of SSMS.
Okay, but you can still do this. I do it all the time.
Guy has a domain login, right? On SQL Server, grant db_datareader to only the necessary columns on the necessary tables. Then create Access front end .mdb that links to those tables. I promise, he can't see more than what you let him see. And since he doesn't have SQL Server client tools, he can't get access to the data via SSMS (big assumption I'm making here).
EDIT: Doh, forgot to mention the use of a File System ODBC for the Access db to connect to SQL Server.
The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems and I don't want yet another person hitting the main machine. I'd drop him on Dev, but I don't want to hear it when Dev goes down as it should from time to time.
I appreciate the permissions advice as I don't normally get to play with those and the clarification of what I'd do is very helpful.
One other problem of doing it the way you suggest is convinving the other business people currently hitting the database that his additional access wouldn't cause them problems.
I know the feeling
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 6, 2010 at 11:51 am
Wow - 2 more posts for 20,000
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 6, 2010 at 11:52 am
tempting tempting tempting
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 6, 2010 at 11:52 am
Everyone remember what this thread is all about? Let me remind those that may have forgotten:
Michael Earl-395764 (11/18/2008)
Is it me, or are the posted questions getting worse these days?I just read a post by someone apparently in charge of something who was asking how to take a database backup and restore it on another server.
It seems like the general feeling of a lot of DBA's (term used loosely) these days is that they do not need to learn anything by reading or studying and they should simply post questions without doing any work themselves. I would expect that they can click the search button at least once before posting a question in a forum.
Anyone else disappointed lately, or am I just getting bitter?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 6, 2010 at 11:52 am
WayneS (10/6/2010)
[Heavy Sigh]
okay, wait mode on. This will be on your blog?
Well, yes. 😀
It's for the T-SQL Tuesday blog 'party' so *shock* *horror* you'll have to wait for the details until tuesday.
I know anticipation is painful but... 😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 11:52 am
OK, I could no longer resist!!!!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 6, 2010 at 11:52 am
Celebration time!!!!! 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 6, 2010 at 11:53 am
Stefan Krzywicki (10/6/2010)
The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems and I don't want yet another person hitting the main machine. I'd drop him on Dev, but I don't want to hear it when Dev goes down as it should from time to time.
Ah, yes. That is an issue I well understand. So I take it he needs it so urgently that you don't have time to get the SQL Express install blessing?
October 6, 2010 at 11:53 am
It looks like Alvin got it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 6, 2010 at 11:54 am
Alvin Ramard (10/6/2010)
Grant Fritchey (10/6/2010)
Maybe I've gone round the bend. Possibly senility has finally kicked in good and hard. Maybe it's just me, but does this sound a little bit nuts to anyone else?They're planning to:
A) toss normalization
B) Use GUIDs but no other unique constraints
C) Toss RI because it's "too much work"
D) Use triggers for RI instead
Unless I'm completely missing the boat because of encroaching senility, insanity or just plain old stupidity.
Grant, your link is not working.
I think you meant: http://www.sqlservercentral.com/Forums/Topic998790-373-1.aspx#bm999605
Yep. That's the one. Thanks. I can't seem to edit the post. It won't go into edit mode when I click on it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2010 at 11:55 am
Alvin Ramard (10/6/2010)
Celebration time!!!!! 😀
And another celebration in about 250 posts as we pass 1,000,000 on the counter.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2010 at 11:56 am
CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.
With a very appropriate post...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 11:56 am
Brandie Tarvin (10/6/2010)
Stefan Krzywicki (10/6/2010)
The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems and I don't want yet another person hitting the main machine. I'd drop him on Dev, but I don't want to hear it when Dev goes down as it should from time to time.Ah, yes. That is an issue I well understand. So I take it he needs it so urgently that you don't have time to get the SQL Express install blessing?
Since our server team is in flux and they're also our install/support team, I think it'd probably take a month or so to get the blessing and the setup. I think they want the table this week.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 6, 2010 at 11:58 am
GilaMonster (10/6/2010)
CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.With a very appropriate post...
Yes - but some bird is whispering to me that he was doing it as a joke too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 19,996 through 20,010 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply