I'm using sql server 2005 express edition on a HP Pavillon machine with windows vista
when I conect the computer to a network the database engine spends about 30 minutes in a query an when is not conected it takes only one second.
What mast i do to correct this problem ?
Thanks
Max.
SQL Server 2005 Express is designed for local connection. For remote connection, you need to purchase SQL Server 2005.I have my computer clean with windows 2000 server SP4
then I install Visual Studio.NET 2005 Professional (With SQL Server 2005 Express Edition) - Everything is OK!
after that i try to install SQL Server 2005 Enterprise Edition, but I get an error message at the begining as following:
Title: setup.exe - Entry Point Not Found
Content: The procedure entry point _encode_pointer could not be located in the dynamic link library MSVCR80.dll
so, is there anybody can help me to solve this problem? thanks!
You may want to post this in the setup section - they have a lot more information there and might have this question answered already.I have my computer clean with windows 2000 server SP4
then I install Visual Studio.NET 2005 Professional (With SQL Server 2005 Express Edition) - Everything is OK!
after that i try to install SQL Server 2005 Enterprise Edition, but I get an error message at the begining as following:
Title: setup.exe - Entry Point Not Found
Content: The procedure entry point _encode_pointer could not be located in the dynamic link library MSVCR80.dll
so, is there anybody can help me to solve this problem? thanks!
You may want to post this in the setup section - they have a lot more information there and might have this question answered already.Hi,
I use Visual Web Developer 2005 Express Edition. Anybody help me how can i use reports and subreports with parameters in it. I am new to ASP.NET. Please give me a sample. Thanks in advance.
Take a look at this article "Adding a Subreport with Parameters", it might be able to help you.
http://msdn2.microsoft.com/en-US/library/aa337490.aspx
Hope this helps.
Jarret
TITLE: Connect to Server
I have downloaded the sql server express edition 2005 .When i open Sql Server Management Studio i am unable to connect this is the error message Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
hi,
are you sure this is the exact exception you are reported with, or does the error message say "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection"?
if this is the case, SQLExpress install by default disabling standard SQL Server authenticated connections.. only WinNT trusted connections will be available.. you can thus connect via a local Windows account member of the local\administrators group, as this group is by default granted login to local SQL Server instances...
once you are connected, you cane use SQL Server Management Studio to modify this behaviour after install time... you can select the "server"'s properties and, in the "security" tab (ok, it's no longer a tab, but I hope you understand my meaning) and enable "SQL Server and Windows authentication mode".. this will enable mixed security authentication, allowing you to connect with standard SQL Server logins..
as regard "sa" login, please verify it's property (node Security->Logins) and, in the "status" tab (again, it's no longer a tab :D) check that the login is "enabled"..
regards
|||Hi,
I was able to connect to sql server with local Windows account member of the local\administrators group.now in "server"'s properties and, in the "security" tab which one is SQL Server and Windows authentication mode".. I am able to see only the logins
1. Builtin/Administrator
2.BUILTIN/Users
3.Khatri/SQLSERVER2005MSFTEUSER$KHATRI$MSSQLSERVER
4.Khatri/SQLSERVER2005MSSQLUSER$KHATRI$MSSQLSERVER
5.NT AUTHORITY\SYSTEM
6.Sa
and also i see tht-for all the above login properties , In the status tab permession is grant and login is enabled for all the above,In the general tab i am unable to select any of them as they disabled or out of focus.
Which one to select?Please help me out
Thank You
Amitha.
|||
hi,
>1. Builtin/Administrator
>2.BUILTIN/Users
>3.Khatri/SQLSERVER2005MSFTEUSER$KHATRI$MSSQLSERVER
>4.Khatri/SQLSERVER2005MSSQLUSER$KHATRI$MSSQLSERVER
>5.NT AUTHORITY\SYSTEM
al these are WinNT related logins, used someway with trusted connections...
you only have
>6.sa
as standard SQL Server login...
after you modify the security setting, you have to restart the service in order standard SQL Server authenticated logins to be granted connection...
>and also i see tht-for all the above login properties , In the status tab permession is >grant and login is enabled for all the above,In the general tab i am unable to select >any of them as they disabled or out of focus.
please excuse me, but I'm unable to understand your requirements.. can you please expand on this?
thank you
