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.Hi, I am new to reporting services 2005 express. Is there a website, SDK, or any other source for help (online and offline) on reporting services so that it can be used for help while creating reports or for learning purposes?
Regards, Sandy
When you install reporting services it asks you whether to install books online, samples etc.
If you mark that option, you will have installed some sample reports which some of them are deployed on the sql server - they will appear on the 'Microsoft Sql Server 2005' tab as a new sub-tab 'Reporting services'
There is also some source code illustrating how to access deployed reports.
Cheers,
Yani
Hi ,
I have a requirement to migrate the data from an existing MS Access database to a newly designed SQL Express 2005 database . Need less to say the table structures in both are totally different.I would like to know how can i handle a scenerio where i want to map table A in access to table B in SQL express (the schema of both different and the number of columns can vary too) , how do i migrate the data from table A in Access to Table B in SQL express using SSMA?
Also i would appreciate if some one can tell me is SSMA the right tool for this , or should i use the upsizing wizard of MS Access.If there is no change in schema between source and destination databases (more of upsizing) then the process is pretty straight forward , The constraint here is that the data needs to be migrated to a new schema where the column names and number of columns can vary between the source table and destination table.. I just need to migrate data only and no other objects.
Need Help!
Thanks
Mahesh
Hi Mahesh,
SSMA is a right tool for migration
http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en and refer discussion at TechNet for troubleshooting http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.sqlupsizing&cat=en_us_FB980B1A-C148-9C19-560F-548B843A67AB&lang=en&cr=us
and refer this thread too http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1033679&SiteID=1
Hemantgiri S. Goswami
I built a web application using my VS2005 installation, which includes SQL Server Express.
All works nicely. However, when I tried to move this application to a system with SQL Server Developer, I cannot get it to work at all - data access receives several errors, with the most common being this one:
Cannot open database "xyz.mdf" requested by the login. The login failed. Login failed for user 'MACHINE\ASPNET'.
Here is my connection string (with specific names changed, obviously):
Data source=MACHINE;Initial Catalog=xyz.mdf;Integrated Security=SSPI;User=Me;Password=MyPassword
I have given users MACHINE\ASPNET and MACHINE\Me all possible permissions (that I know) within SQL Server.
I have spent days on this, with no solution - help would be most appreciated.
use the following syntax for the connection string
<connectionStrings> <add name="DatabaseConnection" connectionString="Data Source=(local);Initial Catalog=Northwind;IntegratedSecurity=SSPI;" /></connectionStrings>|||
Thank you!
I must admit, I do not exactly understand the difference between my example and yours - but yours worked!
Much appreciated.
|||Hi,
This is because unlike SQL Express, connecting to the SQL Server Developer edition requires you to use the instance name instead of the database file name.
Also, you need to remove the username and password to make sure that you're connecting with the windows integrated authentication.
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.http://msdn.microsoft.com/vstudio/express/sql/download/
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
can you help me how step by step I have to do:
right click database(example I've created database name"dotnetnuke")?
then choose properties->choose permissions?
Or can you tell me TSQL command...?
Thank you very much!
|||I've created new users name"dnnusers" and set some permissions but I've recieved some instructions:
"Grant failed for Database 'DotNetNuke'. (Microsoft.SqlServer.Smo)"why?
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
im using the the login controls with asp.net
when i test locally everything works great, its see the ASPNETDB.MDF file, checks the login info and passes the user on to the next page.
However when i move the application to the live server it fails, it cant find the datasource that contains users/password etc. here is there error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
So im missing something here, im used to connecting directly to a remote SQL database and accessing the info from there.
Can someone point me in the right direction? Can the MDF file not be used off the server itself without SQL express installed? Do i need to migrate those tables into a real SQL database?
Thanks,
Sean
installed SQL express on the webserver and it seems to work better now.
I dont get the same error however the user can not login, each time i get "invalid login etc".
If i use the local debug mode it will login correctly.
:(
Any ideas where i need to look?|||
still no luck with this.
can anyone help me understand the process of moving a sql express DB to a production enviroment with SQL Server 2000?
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
