Perpetual connection

Does anyone know the purpose of sp_trace_getdata and if it is normal for it
to run all the time. We have 2 production servers (mostly the same SQL
settings) so I am not sure why this is constantly running on one server and
not the other?
thanks
Meenal
sp_trace_getdata shows up when you are tracing SQL server activity, using
profiler or other means. You should see a number next to this. and that is
the ID of the trace. You can run the following sql to get more information
on that trace:
select * from ::fn_trace_getinfo(id)
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:%232tCyirOFHA.3668@.TK2MSFTNGP14.phx.gbl...
> Does anyone know the purpose of sp_trace_getdata and if it is normal for
> it
> to run all the time. We have 2 production servers (mostly the same SQL
> settings) so I am not sure why this is constantly running on one server
> and
> not the other?
> thanks
> Meenal
>
sql

Perpetual connection

Does anyone know the purpose of sp_trace_getdata and if it is normal for it
to run all the time. We have 2 production servers (mostly the same SQL
settings) so I am not sure why this is constantly running on one server and
not the other?
thanks
Meenalsp_trace_getdata shows up when you are tracing SQL server activity, using
profiler or other means. You should see a number next to this. and that is
the ID of the trace. You can run the following sql to get more information
on that trace:
select * from ::fn_trace_getinfo(id)
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:%232tCyirOFHA.3668@.TK2MSFTNGP14.phx.gbl...
> Does anyone know the purpose of sp_trace_getdata and if it is normal for
> it
> to run all the time. We have 2 production servers (mostly the same SQL
> settings) so I am not sure why this is constantly running on one server
> and
> not the other?
> thanks
> Meenal
>

Perpetual connection

Does anyone know the purpose of sp_trace_getdata and if it is normal for it
to run all the time. We have 2 production servers (mostly the same SQL
settings) so I am not sure why this is constantly running on one server and
not the other?
thanks
Meenalsp_trace_getdata shows up when you are tracing SQL server activity, using
profiler or other means. You should see a number next to this. and that is
the ID of the trace. You can run the following sql to get more information
on that trace:
select * from ::fn_trace_getinfo(id)
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:%232tCyirOFHA.3668@.TK2MSFTNGP14.phx.gbl...
> Does anyone know the purpose of sp_trace_getdata and if it is normal for
> it
> to run all the time. We have 2 production servers (mostly the same SQL
> settings) so I am not sure why this is constantly running on one server
> and
> not the other?
> thanks
> Meenal
>

Permission problem

Hi All,
One of my costumers have a program that connects to a servers MSDE
database.
The name of the program is Winfinance.
Trough DbaMGR2k i have granted a Windows 2003 security group full
permissions on the database.
When a client uses the program to connect to the MSDE database using
Windows authentication there is no problems at all.
However the company would like to make it possible for the staff to
dial in using PPTP VPN.
The PPTP VPN server is the router, so the users never authenticate
trough windows, and thereby can't connect to the MSDE database.
I've tried using the SA account, and by creating another account, with
no luck however.
I'm all out of ideas, if somebody have a shot in the dark i'd really
appreciate it.
Have a nice day.
SQL Server has two Authentication mode: Windows Authentication mode and
mixed mode (Windows and SQL Server). By default installation, it is most
likely, your MSDE is set "Windows Authentication" mode only. If your users
who access the SQL Server cannot be authenticated by its Windows user
account, then you need to enable the mixed authentication mode before you
can use a UserName/Password pair to access the database (never use SA for
the application access).
If you have Enterprise Manager, enable mixed authentication mode is an easy
task. I do not know the tool "DbaMGR2k" can do that or not. If not, search
the web/MS KB for article(s) on how to enable MSDE's mixed security mode.
"Tokatrash" <martin@.deamon.dk> wrote in message
news:1174934720.662175.286260@.n59g2000hsh.googlegr oups.com...
> Hi All,
> One of my costumers have a program that connects to a servers MSDE
> database.
> The name of the program is Winfinance.
> Trough DbaMGR2k i have granted a Windows 2003 security group full
> permissions on the database.
> When a client uses the program to connect to the MSDE database using
> Windows authentication there is no problems at all.
> However the company would like to make it possible for the staff to
> dial in using PPTP VPN.
> The PPTP VPN server is the router, so the users never authenticate
> trough windows, and thereby can't connect to the MSDE database.
> I've tried using the SA account, and by creating another account, with
> no luck however.
> I'm all out of ideas, if somebody have a shot in the dark i'd really
> appreciate it.
> Have a nice day.
>
|||hi,
Norman Yuan wrote:
> If you have Enterprise Manager, enable mixed authentication mode is
> an easy task. I do not know the tool "DbaMGR2k" can do that or not.
> If not, search the web/MS KB for article(s) on how to enable MSDE's
> mixed security mode.
yes it can.. :D
access the server property (server node, rx click) and set the
authentication method accordingly to your needs (mixed mode)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi,
> Norman Yuan wrote:
>
> yes it can.. :D
> access the server property (server node, rx click) and set the
> authentication method accordingly to your needs (mixed mode)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
I will look into that, thank you both!
--Andrea is it you who have developed DbaMgr2k?
|||On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi,
> Norman Yuan wrote:
>
> yes it can.. :D
> access the server property (server node, rx click) and set the
> authentication method accordingly to your needs (mixed mode)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
I tried changing it to mixed mode (it WAS set to Windows
authentication) however now i get the following error:
Login failed for user 'USERNAME' . Reason:Not associated with a
trusted SQL Server connection.
Any ideas?
|||Show your ConnectionString. If you have "Trusted_Connection=True" in
ConnectionString, then the connection is using Windows Authentication, which
is not what you want.
"Tokatrash" <martin@.deamon.dk> wrote in message
news:1175025048.091479.34930@.n76g2000hsh.googlegro ups.com...
> On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
> wrote:
> I tried changing it to mixed mode (it WAS set to Windows
> authentication) however now i get the following error:
> Login failed for user 'USERNAME' . Reason:Not associated with a
> trusted SQL Server connection.
> Any ideas?
>
|||On Mar 27, 10:17 pm, "Norman Yuan" <NotR...@.NotReal.not> wrote:[vbcol=seagreen]
> Show your ConnectionString. If you have "Trusted_Connection=True" in
> ConnectionString, then the connection is using Windows Authentication, which
> is not what you want.
> "Tokatrash" <mar...@.deamon.dk> wrote in message
> news:1175025048.091479.34930@.n76g2000hsh.googlegro ups.com...
>
>
>
There is no connection string visible to me, i'm using a program
called Winfinance to connect to the MSDE database.
It is that program that gives me that error.
|||Either that program was hard coded to use Windows Authentication (if so, bad
design), or there is someway to configure how the program to connect to SQL
Server (very likely), you just need to find where and how to configure it.
"Tokatrash" <martin@.deamon.dk> wrote in message
news:1175031217.284824.59580@.p77g2000hsh.googlegro ups.com...
> On Mar 27, 10:17 pm, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> There is no connection string visible to me, i'm using a program
> called Winfinance to connect to the MSDE database.
> It is that program that gives me that error.
>
|||hi,
Tokatrash wrote:

> --Andrea is it you who have developed DbaMgr2k?
yes, it's me.. please no insults :D
did you restart the MSDE service?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||On Mar 28, 3:32 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi,
> Tokatrash wrote:
> yes, it's me.. please no insults :D
> did you restart the MSDE service?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
Sorry... been away for a while...
No insults at all... just wanted to thank you for a great program...
I tried restarting the MSDE service... no changes... it's really
quite odd.. i really need to be able to connect without using windows
authentication...

Permission concept MSSQL05

Hello
I am looking for any advices or drafts for a new concept how to handle
all the permission to our DB Servers. We are still using SQL2k and
want migrate to SQL05 till the end of the year. Therefore we want to
improve our security with less complexity.
Our productive environment contains 7 MSSQL 2000 Servers with almost
70 DBs. Each Server has its own security-DB where all the rolls are
stored and their permission to each DB.
An advantage of this is that we can run a refresh of all permissions
anytime. On the other hand we have to add all the permissions manually
to that security-DB. This DB does not contain the schemas which will
come which the migration of SQL05.
I would appreciate some information or any links about security
concepts in SQL2005. I am not looking for a complete solution, just
for ideas.
Regards
Martin FrickDBA (martin-za.frick@.ubs.com) writes:
> I am looking for any advices or drafts for a new concept how to handle
> all the permission to our DB Servers. We are still using SQL2k and
> want migrate to SQL05 till the end of the year. Therefore we want to
> improve our security with less complexity.
> Our productive environment contains 7 MSSQL 2000 Servers with almost
> 70 DBs. Each Server has its own security-DB where all the rolls are
> stored and their permission to each DB.
> An advantage of this is that we can run a refresh of all permissions
> anytime. On the other hand we have to add all the permissions manually
> to that security-DB. This DB does not contain the schemas which will
> come which the migration of SQL05.
Well, anything that worked in SQL 2000 will work in SQL 2005, but of
course SQL 2005 will offer you more choices, and there are of course
some chances you want to use that. Not the least the fact that you
can grant rights on schema level can make things simpler, and for
instance you don't have to grant rights on every single procedure.
There are also more privileges, for instance users need VIEW DEFINITION
to be able to see the metadata for an object.
Overall, there are tons of changes in the security area.
So there is a risk that you will have to vamp up your security database
quite a bit.

> I would appreciate some information or any links about security
> concepts in SQL2005. I am not looking for a complete solution, just
> for ideas.
The obvious start is Books Online for SQL 2005. There is a
chapter about Security considerations under Database Engine.
For more details on a special features when it comes to stored procedure,
you may be interested in an article on my web site:
http://www.sommarskog.se/grantperm.html
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx