Prev: Converting spatial values
Next: Alternative to Ms sql server 2005 express edition
From: Keith G Hicks on 11 May 2010 15:42
I jsut set up a new windows 7 machine. Previously running all my dev work on
XP. I know there are issues with SQL 2005 in Windows 7. When I oepend up
SSMS to log into SQL I could use SQL authentication but not Windows
authentication. (I do have it set for mixed mode). I've never had this issue
with XP. I can either use widows auth or sql auth. Either way it works fine.
Far as I know I have SQL set up the same way on both machines. Any ideas?

Thanks,

Keith


From: Uri Dimant on 12 May 2010 03:18
Keith G Hicks
Hmm I have neve seen that problem when I connected to SS2005/2008 . What if
you right click on SSMS and run as administrator open SSMS, does it work?



"Keith G Hicks" <krh(a)comcast.net> wrote in message
news:eXXbaIU8KHA.4604(a)TK2MSFTNGP04.phx.gbl...
>I jsut set up a new windows 7 machine. Previously running all my dev work
>on XP. I know there are issues with SQL 2005 in Windows 7. When I oepend up
>SSMS to log into SQL I could use SQL authentication but not Windows
>authentication. (I do have it set for mixed mode). I've never had this
>issue with XP. I can either use widows auth or sql auth. Either way it
>works fine. Far as I know I have SQL set up the same way on both machines.
>Any ideas?
>
> Thanks,
>
> Keith
>


From: Keith G Hicks on 12 May 2010 09:50
That was it Uri. Thanks. I'm new to W7 so I guess I'll have to get used to
that option.


"Uri Dimant" <urid(a)iscar.co.il> wrote in message
news:ObnGvMa8KHA.5412(a)TK2MSFTNGP06.phx.gbl...
> Keith G Hicks
> Hmm I have neve seen that problem when I connected to SS2005/2008 . What
> if you right click on SSMS and run as administrator open SSMS, does it
> work?
>
>
>
> "Keith G Hicks" <krh(a)comcast.net> wrote in message
> news:eXXbaIU8KHA.4604(a)TK2MSFTNGP04.phx.gbl...
>>I jsut set up a new windows 7 machine. Previously running all my dev work
>>on XP. I know there are issues with SQL 2005 in Windows 7. When I oepend
>>up SSMS to log into SQL I could use SQL authentication but not Windows
>>authentication. (I do have it set for mixed mode). I've never had this
>>issue with XP. I can either use widows auth or sql auth. Either way it
>>works fine. Far as I know I have SQL set up the same way on both machines.
>>Any ideas?
>>
>> Thanks,
>>
>> Keith
>>
>
>


From: Uri Dimant on 12 May 2010 10:24
yep, I am glad it solved your problem

"Keith G Hicks" <krh(a)comcast.net> wrote in message
news:%23FEijod8KHA.3540(a)TK2MSFTNGP06.phx.gbl...
> That was it Uri. Thanks. I'm new to W7 so I guess I'll have to get used to
> that option.
>
>
> "Uri Dimant" <urid(a)iscar.co.il> wrote in message
> news:ObnGvMa8KHA.5412(a)TK2MSFTNGP06.phx.gbl...
>> Keith G Hicks
>> Hmm I have neve seen that problem when I connected to SS2005/2008 . What
>> if you right click on SSMS and run as administrator open SSMS, does it
>> work?
>>
>>
>>
>> "Keith G Hicks" <krh(a)comcast.net> wrote in message
>> news:eXXbaIU8KHA.4604(a)TK2MSFTNGP04.phx.gbl...
>>>I jsut set up a new windows 7 machine. Previously running all my dev work
>>>on XP. I know there are issues with SQL 2005 in Windows 7. When I oepend
>>>up SSMS to log into SQL I could use SQL authentication but not Windows
>>>authentication. (I do have it set for mixed mode). I've never had this
>>>issue with XP. I can either use widows auth or sql auth. Either way it
>>>works fine. Far as I know I have SQL set up the same way on both
>>>machines. Any ideas?
>>>
>>> Thanks,
>>>
>>> Keith
>>>
>>
>>
>
>


 | 
Pages: 1
Prev: Converting spatial values
Next: Alternative to Ms sql server 2005 express edition