January 31, 2012 at 8:25 am
I got a new Windows 7 pc to replace my XP one, and am now having a problem doing a "Run as Different User."
I have two logins to our domain. I use my "regular" account to login into my pc each day. The "enhanced" one has additional rights on the network and our dbs. I use it to login to SSMS, Redgate, production servers, etc. when I need to do something that my "regular" account doesn't have right to. I have always used the "Run as different user" option so I can just open that app with the enhanced rights.
On my new Windows 7 box, everything works great under my "regular" account. Everything works great if I log into my pc under my "enhanced" account. I can open SSMS just fine when I log into my pc under my "regular" account and do a "Run as different user" to open SSMS. However, when I attempt to do a FILE-OPEN to access any existing script I have written, SSMS closes down. Below is what I see in the log. I can open a New Query window and execute it but I can't access an existing script that I have saved.
I'm not seeing this problem listed on forums. Has anyone seen this or know of a fix?
Thanks much for any help!
Log Name: Application
Source: Application Error
Date: 1/31/2012 8:39:55 AM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: BlahBlahBlah.com
Description:
Faulting application name: Ssms.exe, version: 2007.100.1600.22, time stamp: 0x48753da6
Faulting module name: msenv.dll, version: 8.0.50727.1826, time stamp: 0x480d6b43
Exception code: 0xc0000005
Fault offset: 0x0049bff9
Faulting process id: 0xde0
Faulting application start time: 0x01cce0260e095a64
Faulting application path: C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe
Faulting module path: c:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\msenv.dll
Report Id: 70c087f4-4c19-11e1-a877-d067e5282766
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Application Error" />
<EventID Qualifiers="0">1000</EventID>
<Level>2</Level>
<Task>100</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2012-01-31T14:39:55.000000000Z" />
<EventRecordID>10418</EventRecordID>
<Channel>Application</Channel>
<Computer>BlahBlahBlah.com</Computer>
<Security />
</System>
<EventData>
<Data>Ssms.exe</Data>
<Data>2007.100.1600.22</Data>
<Data>48753da6</Data>
<Data>msenv.dll</Data>
<Data>8.0.50727.1826</Data>
<Data>480d6b43</Data>
<Data>c0000005</Data>
<Data>0049bff9</Data>
<Data>de0</Data>
<Data>01cce0260e095a64</Data>
<Data>C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe</Data>
<Data>c:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\msenv.dll</Data>
<Data>70c087f4-4c19-11e1-a877-d067e5282766</Data>
</EventData>
</Event>
January 31, 2012 at 8:57 am
I have a similar setup and it all works ok for me. Are both accounts local admins? I could imagine the lower privilage stuff Windows 7 does wouldn't work so well using Run As (it's not quite the same as logging on as another user).
Are you opening the files from a location that's not part of either user space? I have definitely had issues when opening a file in the Documents folder of one user, whilst running the application as the other user, even though both had access to the folder.
January 31, 2012 at 11:49 am
Both accounts are local admins...we had already checked that. It doesn't even get to the point of generating the list of drives I am mapped to. I'm going re-apply SP3, and see if that helps. I loaded SQL2005 Integration Services on my pc after I had loaded SQL2008 and maybe that hosed something up. Thanks for the reply. It's good to know that it SHOULD work.
February 1, 2012 at 4:41 am
February 1, 2012 at 1:33 pm
JohnItech, thanks for the link but that logs me into SSMS with the same permissions as my regular account. I need to have additional permissions granted to me under my "enhanced" account.
I feel incredibly stupid now that I know what I was doing. The default when you do FILE-OPEN is to look in the "My Projects" folder. All I need to do is switch it to look in "My Computer" and it works just fine. I never save anything in "My Projects" anyway.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply