SQL Server远程调试失败
前言 刚刚打开SQL Server 2008，想要新建一个数据库。发现出现了一个问题，这个问题由于之前没有遇到过，所以这次拿出来记录一些解决方式。 内容 出现上面这个错误的原因可能是由于咱们在装VS2012或者其他版本的时候，这个VS会自动装“Microsoft SQL Server
前言
刚刚打开SQL Server 2008，想要新建一个数据库。发现出现了一个问题，这个问题由于之前没有遇到过，所以这次拿出来记录一些解决方式。
内容
出现上面这个错误的原因可能是由于咱们在装VS2012或者其他版本的时候，这个VS会自动装“Microsoft SQL Server 2013（2012） ExpressLocalDB”服务，所以导致SQL server2008，中SQL server服务显示远程过程调用失败。知道了原因解决其他就相当简单了。
第一：采用温柔的方式
乖乖地升级自己的数据库为更高的版本。
第二：将就一下
如果只用这一次数据库，就去计算机→管理→服务，找到要开启的服务SQLserver（MSSQL SERVER）去启动就OK了。
第三：不将就
当然生活嘛，就得学会不将就，因为米老师说的：不将就是发现的原动力。所以呢，为了每次使用都能正常使用，只能委屈“Microsoft SQL Server 2013（2012） ExpressLocalDB”这个服务了，鱼与熊掌不可兼得。所以去控制面板果断的找到这个自动安装的服务，去卸载它吧，对VS没有大影响。卸载后，然后开启SQL server服务下的需要的服务即可。
话说回来了，VS为什么要自动装“Microsoft SQL Server 2013（2012） ExpressLocalDB”，宝宝真不知道，不过看表面意思，应该是一个本地数据库什么的？？？百度告诉我说：VS2012中提供了一个本地数据库引擎“Microsoft SQL Server 2013（2012） ExpressLocalDB”，通过VS2012可以很方便管理和使用本地数据库。
小结
1、不将就是发现的原动力。
感谢您的宝贵时间···
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1386
52
Detailed explanation of C++ function debugging: How to debug problems in multi-threaded functions?
May 02, 2024 pm 04:15 PM
C++ multi-thread debugging can use GDB: 1. Enable debugging information compilation; 2. Set breakpoints; 3. Use infothreads to view threads; 4. Use thread to switch threads; 5. Use next, stepi, and locals to debug. Actual case debugging deadlock: 1. Use threadapplyallbt to print the stack; 2. Check the thread status; 3. Single-step the main thread; 4. Use condition variables to coordinate access to solve the deadlock.
How to use LeakSanitizer to debug C++ memory leaks?
Jun 02, 2024 pm 09:46 PM
How to use LeakSanitizer to debug C++ memory leaks? Install LeakSanitizer. Enable LeakSanitizer via compile flag. Run the application and analyze the LeakSanitizer report. Identify memory allocation types and allocation locations. Fix memory leaks and ensure all dynamically allocated memory is released.
Shortcut to golang function debugging and analysis
May 06, 2024 pm 10:42 PM
This article introduces shortcuts for Go function debugging and analysis, including: built-in debugger dlv, which is used to pause execution, check variables, and set breakpoints. Logging, use the log package to record messages and view them during debugging. The performance analysis tool pprof generates call graphs and analyzes performance, and uses gotoolpprof to analyze data. Practical case: Analyze memory leaks through pprof and generate a call graph to display the functions that cause leaks.
How to debug PHP asynchronous code
May 31, 2024 am 09:08 AM
Tools for debugging PHP asynchronous code include: Psalm: a static analysis tool that can find potential errors. ParallelLint: A tool that inspects asynchronous code and provides recommendations. Xdebug: An extension for debugging PHP applications by enabling a session and stepping through the code. Other tips include using logging, assertions, running code locally, and writing unit tests.
How to conduct concurrency testing and debugging in Java concurrent programming?
May 09, 2024 am 09:33 AM
Concurrency testing and debugging Concurrency testing and debugging in Java concurrent programming are crucial and the following techniques are available: Concurrency testing: Unit testing: Isolate and test a single concurrent task. Integration testing: testing the interaction between multiple concurrent tasks. Load testing: Evaluate an application's performance and scalability under heavy load. Concurrency Debugging: Breakpoints: Pause thread execution and inspect variables or execute code. Logging: Record thread events and status. Stack trace: Identify the source of the exception. Visualization tools: Monitor thread activity and resource usage.
What are the debugging techniques for recursive calls in Java functions?
May 05, 2024 am 10:48 AM
The following techniques are available for debugging recursive functions: Check the stack traceSet debug pointsCheck if the base case is implemented correctlyCount the number of recursive callsVisualize the recursive stack
PHP Debugging Errors: A Guide to Common Mistakes
Jun 05, 2024 pm 03:18 PM
Common PHP debugging errors include: Syntax errors: Check the code syntax to make sure there are no errors. Undefined variable: Before using a variable, make sure it is initialized and assigned a value. Missing semicolons: Add semicolons to all code blocks. Function is undefined: Check that the function name is spelled correctly and make sure the correct file or PHP extension is loaded.
Detailed explanation of C++ function debugging: How to debug problems in functions that contain exception handling?
Apr 30, 2024 pm 01:36 PM
C++ debugging functions that contain exception handling uses exception point breakpoints to identify exception locations. Use the catch command in gdb to print exception information and stack traces. Use the exception logger to capture and analyze exceptions, including messages, stack traces, and variable values.
