which edition of sql server are best for me Developer edition or express editon for development purpose.i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.
View 7 Repliesi am trying to install "sql server management Studio R2 " i am getting this error
"Previous releases of Microsoft Visual Studio 2008″ failed.A previous release of Microsoft Visual Studio 2008 is installed on this computer. "
my system i am having sql server 2005 standard edition.now i installed sql server 2008 r2 express edition and i am getting error like.."the service did not respond to the start or contorl request in a timely fashion"...
is it possible to install sql server 2008 r2 express edition in a system where sql server 2005 standard edition is already installed?
i have installed sql 2005 more than 100 times , but this time
View 3 Replieswhen i try to install sql server 2005 in my laptop its shows warning that my IIS might be not install or diable.i install IIS before instaltion of SQL SERVER. its perfly running , i am running my apllication in IISi cant understand why SQL SERVER shows this warnign due to this warning my managment studio is not install .i am using WIndows 7 home premiunam o.s.
View 4 RepliesI am unable to install .net framework 3.5 sp1 on windows server 2003 r2 datacenter x64 sp2 edition.
Are there any bugs or known issues regarding this matter?
FrameWork 2.0 +sp2 and framework 3.0 are already installed.
I'm trying to debug an ASP.NET webapp that's configured to "Use Local IIS Web Server" on WinXP. When I start the debugger, the compile succeeds, and then the following error is displayed in a dialog:
Unable to start debugging on the web server. The COM+ registry database detected a system error
The webapp never launches in my browser. How can I get rid of this message and debug this webapp?
I have SQL server management studio express install on one machine.
I am able to connect to that machine or able to ping that machine from my computer.
I have code which return me the SQL server instances on same network. Using that I am able to get that SQL server instance. I have configured SQL express to access remote connection. i.e.
Configured SQL express to accept named / TCP IP instance connection. Started Browser service.
My machine settings My machine has been configured to set dynamic IP address using DHCP protocol
When I am trying to connect to above mentioned SQL server I am getting error that "Failed to connect SERVER NAME\SQLEXPRESS".
But if I configured my machine with manual IP address and default gateway I am able to connect to same SQL server.
I got the solution to connect to that server but I don't know why I am facing such problem. And also let me know that is the solution I am using is correct or not?
I had this one working a while back i try to upload file to my root folder it works locally but when i try it from my website i get the following error: exception details: system.bet .webexception. unable to connect to the remote server
the code bomb at the following line
requestStream = uploadRequest.GetRequestStream() 'This is where the exception occurs
fileStream = File.Open(localFile, FileMode.Open)
[code]....
This issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
View 3 Repliesin its webconfig file i have
<identity impersonate="true" userName="webserverloginname" password="webserverpassword" />
sername1= username of the system
password1 = passowrd of the system
username2= username of the the database
password2 = passowrd of the database
client system which access the database server aswell as web server
In machine XPSP2, I tried to install SQL SErver 2005 express edition (downloaded from the microsoft site) - after mode selction form (Windows/SQL server authentication) - system restarted, automatically.Again restarted, Again restarted,Again restarted,Again restarted,a 1000 times or more.finally I unplugged the system from the UPS
View 2 RepliesIs it possible to get .NET 4.0 on the server without having to install it? Well! It may sound crazy by just reading the title without actually going into it.
My senior developers(who used to do VB6/ASP programming back then) doesnt want .NET 4.0 on the server for two reasons. 1) They fear that all their existing applications will break. 2) They will be forced to learn new technologies which they dont want.
But unfortunately they are the senior programmers(by age) and are the decision makers.So here is my crazy thought. Is it possible to get .NET framework running on the server without having to install it. What I mean by that is, If I deploy all the .NET 4.0 dlls in the GAC of the server and to add some values into registry. Will I be able to run .NET 4.0 apps on it?
or can we have only certain applications use .NET 4.0 run time and the old applications use .NET 2.0/or 1.1 run time?
The current .NET version on the server is .NET 3.5 SP1.
i want to take the DB Backup from theremote server to the local system..
i'm using sql server2008 enterprise edition and the remote server is sql server2008 express. how to do it..
I have a .Net Webservice(2.0 framework) and I am trying to call this service from SQL
server 2005 using CLR.
I have created assamblies on server and trying to call the we service through CLR, but I'm getting below error:
"Exception:
Server was unable to process request. ---> Invalid URI: The URI is empty."
I tried this code by inputting the ftp address as ftp//: and the correct username and password and I get the following error
"Unable to connect to the remote server" on line :
FtpWebResponse Response = (FtpWebResponse)Request.GetResponse();I tired this on my ftp server provided by a hosting service and an anonymous ftp located at 193.166.120.5 ?
Note: I was able to connect to both of these ftp through filezilla, via a webbrowser, and through windows command line.
I am having issues debugging locally within Visual Studio 2010 on Server 2008 R2 (x64) for a new ASP.Net MVC application. I am able to debug using the VS Development Server (Cassini) but when I change to use the Local IIS Web Server and Create Virtual Directory, I am unable to debug. I get the standard VS message:
"Unable to start debugging on the web server. The web server is not configured correctly. ..."
Everything looks standard in IIS. The Default Web Site is running under the ASP.NET v4.0 application pool. The virtual directory that Visual Studio created is running under the same app pool. I am running Visual Studio as the Administrator account. It feels like some security setting or something is preventing this to work but I'm at a loss to what it could be.
Currently, I am storing images and video clips in my database as a varbinary(max).
The problem is that when my front-end goes to retrieve and play the video, it takes an excessive amount of time to download.
For example, I have a video file: test.avi (5mb). If I attempt to read from database and play avi, it takes about 40 seconds. If I attempt to play this test.avi from the filesystem, it takes about 10 seconds to load.
I have investigated compression/decompression, but those seem to be as time-consuming as just loading up the raw data from the database.
Should I scrap storing video clips in the database, and go for a file system approach. I would really like to keep everything clean, secure, and organized. Which is why I am storing images, video clips, etc. in database.
I am unable to restore database in form of .bak files using Microsoft SQL Server Management Studio Express.It gives following error message:
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)
I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio.I believe the problem is related to a change I made to the connection protocols. Before the error occurred, I had Shared Memory enabled and Named Pipes and TCP/IP disabled. I then enabled both Named Pipes and TCP/IP, and this is when I started experiencing the problem.
I have now set Named Pipes and TCP/IP back to disabled. When I try to connect to the server with SSMS (with either my SQL server sysadmin login or with windows authentication), I get the following error message:
"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)"
My first question here is: why is it returning a Named Pipes error? Why isn't it using Shared Memory? It seems like it is not listening on Shared Memory for some reason?When I set Named Pipes to enabled and try to connect, I get the same error message.My windows account is does not have administrator priviliges on my computer.
I am using VS 2008 with SQL in express edition . I have made my website and hosted it on server with cuteftp .Now i want to change
the website so when i tried to delete all files the App_data folder does not delete .
So i am unable delete my mdf and log file which are in this folder. It says file error.
I always use SQL in design window in VS and know less of coding in SQL.
i just install the sql server 2008.today i try to open sql server management studio for create database, but once i open, a box say connect to server,when click connect,the error 18456 show.May i know what is the problem?my object explorer also doesn't show anything.my pc is windows 7.
View 6 RepliesI have a number of .NET websites that I have to FTP to the same server from time to time. They all make use of AjaxControlToolkit.dll.Is there a way I can register AjaxControlToolkit.dll on the server somehow so I don't need to keep FTPing AjaxControlToolkit.dll to the server for each of the websites that gets built/published.
View 2 RepliesHow to install a Web page on a server?
Is fully copied a web page that is currently on localhost, the database and data as the server?
Currently I'm in the process of deploying my ASP.net MVC 2 project on a Windows Server 2008 R2 web server. This web server already has the .net 4 Framework installed, but doesn't have any MVC dll's in the GAC.
So deployment on IIS succeeds, but when I start up the web application in the browser, it results in this message:
Could not load file or assembly 'System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Of course I can Google myself too and it mainly:
Copying the MVC dll's (System.Web.Mvc.dll, .Routing.dll, etc) to the output directory;
Downloading an RTM version of ASP.net MVC 2 on top of .net 3.5 Framework. Neither of them I'd like to do. I just want to install ASP.net MVC 2 to the GAC of my web server. So my question is:
Which installation does actually contain ASP.net MVC 2 for installation on top of .net 4?